S_NC_ESR_DISTRICT (ver 13.6.0)
This table is an extension of the Pref table. This table is obsolete and is replaced by the S_NC_ELSCHSUMRPT_DISTRICT_S table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 13.6.0 | Number(19,0) | Primary key |
| PREFSDCID | 13.6.0 | Number(19,0) | foreign key to Preferences table |
WhatCreated | 13.6.0 | Varchar2(50) | |
WhatModified | 13.6.0 | Varchar2(50) | |
WhenApproved | 13.6.0 | Date | |
WhenCreated | 13.6.0 | Date | |
WhenModified | 13.6.0 | Date | |
WhoApproved | 13.6.0 | Varchar2(100) | |
WhoCreated | 13.6.0 | Varchar2(100) | |
WhoModified | 13.6.0 | Varchar2(100) | |
YearID | 13.6.0 | Number(11,0) | |
Open_Status | 13.6.0 | Number(1,0) | |
Initialized_On | 13.6.0 | Date | |
Initialization_Detail | 13.6.0 | Varchar2(256) | |
DirectCertification | 14.2.2 | Number(1,0) | |
| DC_Option | 15.5.0 | Number(11,0) | |
| Reserved_Boolean | 15.5.0 | Number(1,0) | |
| Reserved_String | 15.5.0 | Varchar2(100) | |
| Reserved_Integer | 15.5.0 | Number(11,0) | |
| Reserved_Double | 15.5.0 | Number(25,10) | |
| Reserved_Date | 15.5.0 | Date |