CLARITY_UCL_2
Description:
Universal Charge Line information. Each row represents one UCL transaction.

Primary Key
Column Name Ordinal Position
UCL_ID 1

Column Information
Name Type Discontinued?
1 UCL_ID VARCHAR No
The unique identifier (.1 item) for the charge line record.
2 CHARGE_STAGE_C_NAME VARCHAR No
This item stores the current stage for the charge.
May contain organization-specific values: No
Category Entries:
Pre-Handler Review
Charge Handler
Destination Router
Destination Filer
Post-Handler Review
Pre-Process
Repost Review
Triggered
3 CREATED_IN_RTR_YN VARCHAR No
This item indicates whether the charge was created by the charge router.
May contain organization-specific values: No
Category Entries:
No
Yes
4 CREATED_FROM_UCL_ID VARCHAR No
The charge from which this charge was created. This means that whenever a charge is generated from another charge, this item will represent the charge it was created from. If a charge is created manually in the editor, this item will not be set since it wasn't created from another charge.
5 THIRD_PTY_ELIG_YN VARCHAR No
This item indicates whether the charge is third party eligible. This is used by lab charges.
May contain organization-specific values: No
Category Entries:
Yes
No
6 PRO_HOSP_ACCT_ID NUMERIC No
The professional billing hospital account tied to the visit for the guarantor account.
7 PRO_VIS_NUM VARCHAR No
The current professional billing visit for the guarantor account.
8 RESEARCH_ENROLL_ID NUMERIC No
The unique ID of the research study association linked to this charge.
9 ORIG_BILL_AREA_ID NUMERIC No
The item stores the original value of provider bill area.
10 ORIG_BILL_AREA_ID_BILL_AREA_NAME VARCHAR No
The record name of this bill area, financial subdivision, or financial division.
11 DELEGATE_BILL_SOURCE_TX_ID NUMERIC No
The source Tapestry ETR that the charge is linked to.
12 DELEGATE_BILL_SOURCE_CLAIM_ID NUMERIC No
The source Tapestry CLM that the charge is linked to.
13 SPLIT_RELATED_HAR_TYPE_C_NAME VARCHAR No
Identifies the system calculated related HAR type (I HAR 146) of the HAR that this charge will be split to.
May contain organization-specific values: Yes
Category Entries:
Elective Services
ED/Inpatient Split Billing
Leave of Absence / Bed Hold
Interrupted Stay
Separate Service Area Billing
Home Infusion Medical Benefits
Received Self-Pay
Shadow Billing
Home Infusion Bypass
PAS LPR Hospital at Home Visit
Other
14 SPLIT_RELATED_HAR_RULE_ID VARCHAR No
Indicates the rule in the PB Profile that qualified the charge for the related visit account type stored in item 16801.
15 SPLIT_RELATED_HAR_RULE_ID_RULE_NAME VARCHAR No
The name of the rule.
16 SPLIT_RELATED_HAR_SOURCE_C_NAME VARCHAR No
Tracks how the related visit account type stored in UCL item 16801 was set.
May contain organization-specific values: No
Category Entries:
User
System
Charge Router Handler