| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SCPOSID_INT | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | ACTIVE | Status | char | 1 | 0 | | | | Allow NULL? |
| 4 | CHANGEDBY | Version Created By (= Object Changed By) | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | CHANGETIME | Version Created: Date + Time | decimal | 15 | 0 | | | | |
| 6 | INACTIVETIME | Version Deactivated: Date + Time | decimal | 15 | 0 | | | | |
| 7 | EFFFROMTIME | Version Valid From: Date + Time | decimal | 15 | 0 | | | | |
| 8 | EFFTOTIME | Version Valid To: Date + Time | decimal | 15 | 0 | | | | |
| 9 | TERMTIME | Valid-To Date Set: Date + Time | decimal | 15 | 0 | | | | |
| 10 | DELETED | Flag: Deletion Entry? | char | 1 | 0 | | | | Allow NULL? |
| 11 | OSYSID | Original System of Version | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | OMANDT | Client in Original System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | SCPOSID_PREV | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | | | | Allow NULL? |
| 14 | SERVCATID | ID of a Benefits, Services and Fees Catalog | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | SC_VARIANT | Variant of a Benefits/Services/Fee Catalog | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | SCPOSID_EXT | ID of a Benefits Catalog Item | nvarchar | 20 | 0 | | | | Allow NULL? |
| 17 | SCPOSID_AMNTFROM | Lower Interval Limit of a Benefits Catalog Item | decimal | 15 | 2 | | | | |
| 18 | SCPOSID_AMNTTO | Upper Interval Limit of a Benefits Catalog Item | decimal | 15 | 2 | | | | |
| 19 | SCPOS_CURR | Currency of Benefits/Services/Fees Catalog | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | SCPOS_PARENT | Internal ID of Benefits Catalog Item | nvarchar | 32 | 0 | | | | Allow NULL? |
| 21 | SCPOS_TYPE | Type of Benefits Catalog Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | SCPOS_XSEL | Entry Lock for Benefits Catalog Item | char | 1 | 0 | | | | Allow NULL? |
| 23 | BENTYPE | Benefit Type | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | BENTYPE_EXP | BRF: Expression | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | SCPOS_QUANTITY | Evaluation Quantity of Benefits Catalog Item | decimal | 10 | 3 | | | | |
| 26 | SCPOS_QUANTITYTO | Evaluation Quantity of Catalog Item (Upper Limit) | decimal | 10 | 3 | | | | |
| 27 | SCPOS_QUANUNIT | Unit of Benefits Catalog Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | SCPOS_VALPERUNIT | Value per Unit of Benefits Catalog Item | decimal | 20 | 12 | | | | |
| 29 | SCPOS_XREIMBURSE | Reimbursability of a Benefits Catalog Item | char | 1 | 0 | | | | Allow NULL? |
| 30 | SCPOS_XAPPROVAL | Obsolete: Approval Requirement of a Benefits Catalog Item | char | 1 | 0 | | | | Allow NULL? |
| 31 | SCPOS_CALC_EXP | BRFplus Expression for Additional Calculations | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | SCPOS_TXT_EXP | BRFplus Expression for Determination of Text Module | nvarchar | 20 | 0 | | | | Allow NULL? |
| 33 | SCPOS_TAXCODEINV | Type of Sales Tax Calculation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | RV | Relative Value | decimal | 10 | 0 | | | | |
| 35 | RVU | Unit of Measure of Relative Value | nvarchar | 3 | 0 | | | | Allow NULL? |
| 36 | AVLENGTH | Average Length of Stay in Days | decimal | 5 | 2 | | | | |
| 37 | DEDUCTION | First Day of Markdown | decimal | 5 | 2 | | | | |
| 38 | SURCHARGE | First Day of Markup | decimal | 5 | 2 | | | | |
| 39 | LOCALIZATION | Indicator 'Localization Possible' | char | 1 | 0 | | | | Allow NULL? |
| 40 | CATAID | Catalog for Major Diagnostic Categories (MDC) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | DIAGID | Code of an MDC Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | ARCHIVE_STATUS | Archiving Status | char | 1 | 0 | | | | Allow NULL? |
| 43 | ARCHIVE_FLUD | Resubmission Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | REJECTION | Rejection Reason | nvarchar | 2 | 0 | | | | Allow NULL? |
