Table_Name | Column_Name | Data Type | Data Length |
|---|---|---|---|
D1_DYN_OPT | EXT_DYN_OPT_ID_VALUE* | VARCHAR2 | 120 |
D1_DYN_OPT | D1_INITIATIVE_CD* | VARCHAR2 | 30 |
D1_DYN_OPT | D1_APPROVAL_PROF_CD* | VARCHAR2 | 30 |
D1_DYN_OPT | DIVISION_CD* | VARCHAR2 | 30 |
D1_DYN_OPT | START_DT* | DATE | 10 |
D1_DYN_OPT | END_DT* | DATE | 10 |
D1_DYN_OPT | SUSPEND_FLG* | CHAR | 4 |
D1_DYN_OPT_EVENT | DYN_OPT_EVENT_CAT_FLG* | CHAR | 4 |
D1_DYN_OPT_TYPE | DYN_OPT_EVENT_BO_CD* | CHAR | 30 |
D1_DYN_OPT_TYPE | D1_APPROVAL_PROF_CD* | VARCHAR2 | 30 |
D1_DYN_OPT_TYPE | EVENT_PARTICIPATION_BO_CD* | CHAR | 30 |
D1_SP_EQPMN | SEQNO* | NUMBER | 5 |
D1_SP_EQPMN | ACTIVE_INACTIVE_FLG* | CHAR | 4 |
D1_SP_TYPE | SP_CLASS_FLG* | CHAR | 4 |
D1_USAGE_PERIOD_SQ | D1_VARIABLE_NAME* | CHAR | 20 |
D1_USAGE_PERIOD_SQ | D1_FORMULA* | VARCHAR2 | 50 |
D1_US_DYN_OPT | SEQNO* | NUMBER | 5 |
D1_US_SP | SEQNO | NUMBER | 5 |
D1_DYN_OPT_EVENT | DYN_OPT_EXT_ID_VALUE* | VARCHAR2 | 120 |
D1_DYN_OPT_TYPE | DYN_OPT_CATEGORY* | VARCHAR2 | 254 |
D1_DYN_OPT_TYPE | DEVICE_REQD_FLG* | CHAR | 4 |
D1_EVT_PARTICIPATION | RESERVATION_START_DTTM* | DATE | |
D1_EVT_PARTICIPATION | RESERVATION_END_DTTM* | DATE | |
D1_EVT_PARTICIPATION | ILM_DT* | DATE | |
D1_EVT_PARTICIPATION | ILM_ARCH_SW* | CHAR | 1 |
D1_DYN_OPT_EVENT | DYN_OPT_EXT_ID_VALUE* | VARCHAR2 | 120 |
D1_DYN_OPT_TYPE | DYN_OPT_CATEGORY* | VARCHAR2 | 254 |
D1_DYN_OPT_TYPE | DEVICE_REQD_FLG* | CHAR | 4 |
D1_EVT_PARTICIPATION | RESERVATION_START_DTTM* | DATE | 26 |
D1_EVT_PARTICIPATION | RESERVATION_END_DTTM* | DATE | 26 |
D1_EVT_PARTICIPATION | ILM_DT* | DATE | 10 |
D1_EVT_PARTICIPATION | ILM_ARCH_SW* | CHAR | 1 |
D1_SP | D1_INSTALL_DT* | DATE | 10 |