CLP_ATTACHMENTS
Description:
This table stores claim-level attachment information.

Primary Key
Column Name Ordinal Position
CLAIM_PRINT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CLAIM_PRINT_ID NUMERIC No
The unique identifier (.1 item) for the claim record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 ATTACHMENT_ROI_ID VARCHAR No
The attachment record ID containing claim-level attachment information.
4 ATTACHMENT_CONTROL_NUM VARCHAR No
The attachment control number for the attachment.
5 ATTACHMENT_GENERATED_YN VARCHAR No
The indicator that the attachment was generated.
May contain organization-specific values: No
Category Entries:
No
Yes
6 ATTACH_REMOVED_YN VARCHAR No
The indicator that the attachment was removed by a user from a workqueue.
The category values for this column were already listed for column: ATTACHMENT_GENERATED_YN
7 ATTACH_EDITED_YN VARCHAR No
The indicator that the attachment was edited by a user.