Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| cefs_id | int | 4 | null |
|
|
|||
| cefs_insertdate | datetime | 16,3 | null |
|
|
|||
| cefs_lastupdate | datetime | 16,3 | null |
|
|
|||
| cefs_ps | char | 1 | null |
|
|
|||
| cefs_ptid | int | 4 | null |
|
|
|||
| cefs_psid | int | 4 | √ | null |
|
|
||
| cefs_medicareno | varchar | 25 | √ | null |
|
|
||
| cefs_medicareAeffectivedate | datetime | 16,3 | √ | null |
|
|
||
| cefs_medicareBeffectivedate | datetime | 16,3 | √ | null |
|
|
||
| cefs_ub92remarks | varchar | 2147483647 | √ | null |
|
|
||
| cefs_medicaidno | varchar | 25 | √ | null |
|
|
||
| cefs_medicaideffectivedate | datetime | 16,3 | √ | null |
|
|
||
| cefs_claimno | varchar | 15 | √ | null |
|
|
||
| cefs_policyno | varchar | 26 | √ | null |
|
|
||
| cefs_userdefined1 | varchar | 25 | √ | null |
|
|
||
| cefs_userdefined2 | varchar | 25 | √ | null |
|
|
||
| cefs_userdefined3 | varchar | 25 | √ | null |
|
|
||
| cefs_userdefined4 | varchar | 25 | √ | null |
|
|
||
| cefs_userdefined5 | varchar | 25 | √ | null |
|
|
||
| cefs_sbid | int | 4 | null |
|
|
|||
| cefs_primid | int | 4 | √ | null |
|
|
||
| cefs_phmedicaidnumber | varchar | 25 | √ | null |
|
|
||
| cefs_clienteffectivedate | datetime | 16,3 | √ | null |
|
|
||
| cefs_secondaryidentification | varchar | 30 | √ | null |
|
|
||
| cefs_clientcoveredbymedicare | char | 1 | null |
|
|
|||
| cefs_authonfile | char | 1 | null |
|
|
|||
| cefs_authdate | datetime | 16,3 | √ | null |
|
|
||
| cefs_insertedby | varchar | 100 | √ | null |
|
|
||
| cefs_lastupdatedby | varchar | 100 | √ | null |
|
|
||
| cefs_active | char | 1 | null |
|
|
|||
| cefs_inactivatedby | varchar | 100 | √ | null |
|
|
||
| cefs_dateinactivated | datetime | 16,3 | √ | null |
|
|
||
| cefs_msp | char | 1 | √ | null |
|
|
||
| cefs_mspdenial | char | 1 | √ | null |
|
|
||
| cefs_msptid | int | 4 | √ | null |
|
|
||
| cefs_pstid | int | 4 | √ | null |
|
|
||
| cefs_payorcode | varchar | 4 | √ | null |
|
|
||
| cefs_claimorder | int | 4 | √ | null |
|
|
||
| cefs_assignmentofbenefits | char | 1 | null |
|
|
|||
| cefs_epiid | int | 4 | √ | null |
|
|
||
| cefs_ispatientinhmo | char | 1 | √ | null |
|
|
||
| cefs_manualHold | bit | 1 | null |
|
|
|||
| cefs_concurrentSecondaryBilling | char | 1 | null |
|
|
|||
| cefs_splitepisodebilling | bit | 1 | null |
|
|
|||
| cefs_billclialabs | char | 1 | ('N') |
|
|
|||
| cefs_pendingMedicaidNo | char | 1 | null |
|
|
|||
| cefs_systemhold | bit | 1 | null |
|
|
|||
| cefs_manualholdinsertedby | varchar | 150 | √ | null |
|
|
||
| cefs_ClaimBenefitPeriodDate | date | 6 | √ | null |
|
|
||
| cefs_hicn | varchar | 25 | √ | null |
|
|
||
| cefs_caseRateInitialPeriodBeginDateOverride | date | 6 | √ | null |
|
|
||
| AVA_insert_date | datetime2 | 16,3 | (getdate()) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_HCHB_CLIENT_EPISODE_FS | Primary key | Asc | cefs_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors