Z_GLPUPRS_WRK1 |
Default Table Name | Z_GLPUPRS_WRK1 |
Definition |
Z_GLPUPRS_WRK1 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ACCT_ID | VARCHAR2(15) | YES | ||
REF_STRUC_ID | VARCHAR2(20) | YES | ||
FY_CD | VARCHAR2(6) | YES | ||
PD_1_GL_AMT | NUMBER(14, 2) | YES | ||
PD_1_RF_AMT | NUMBER(14, 2) | YES | ||
PD_1_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_2_GL_AMT | NUMBER(14, 2) | YES | ||
PD_2_RF_AMT | NUMBER(14, 2) | YES | ||
PD_2_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_3_GL_AMT | NUMBER(14, 2) | YES | ||
PD_3_RF_AMT | NUMBER(14, 2) | YES | ||
PD_3_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_4_GL_AMT | NUMBER(14, 2) | YES | ||
PD_4_RF_AMT | NUMBER(14, 2) | YES | ||
PD_4_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_5_GL_AMT | NUMBER(14, 2) | YES | ||
PD_5_RF_AMT | NUMBER(14, 2) | YES | ||
PD_5_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_6_GL_AMT | NUMBER(14, 2) | YES | ||
PD_6_RF_AMT | NUMBER(14, 2) | YES | ||
PD_6_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_7_GL_AMT | NUMBER(14, 2) | YES | ||
PD_7_RF_AMT | NUMBER(14, 2) | YES | ||
PD_7_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_8_GL_AMT | NUMBER(14, 2) | YES | ||
PD_8_RF_AMT | NUMBER(14, 2) | YES | ||
PD_8_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_9_GL_AMT | NUMBER(14, 2) | YES | ||
PD_9_RF_AMT | NUMBER(14, 2) | YES | ||
PD_9_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_10_GL_AMT | NUMBER(14, 2) | YES | ||
PD_10_RF_AMT | NUMBER(14, 2) | YES | ||
PD_10_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_11_GL_AMT | NUMBER(14, 2) | YES | ||
PD_11_RF_AMT | NUMBER(14, 2) | YES | ||
PD_11_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_12_GL_AMT | NUMBER(14, 2) | YES | ||
PD_12_RF_AMT | NUMBER(14, 2) | YES | ||
PD_12_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_13_GL_AMT | NUMBER(14, 2) | YES | ||
PD_13_RF_AMT | NUMBER(14, 2) | YES | ||
PD_13_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_14_GL_AMT | NUMBER(14, 2) | YES | ||
PD_14_RF_AMT | NUMBER(14, 2) | YES | ||
PD_14_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_15_GL_AMT | NUMBER(14, 2) | YES | ||
PD_15_RF_AMT | NUMBER(14, 2) | YES | ||
PD_15_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_16_GL_AMT | NUMBER(14, 2) | YES | ||
PD_16_RF_AMT | NUMBER(14, 2) | YES | ||
PD_16_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_17_GL_AMT | NUMBER(14, 2) | YES | ||
PD_17_RF_AMT | NUMBER(14, 2) | YES | ||
PD_17_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_18_GL_AMT | NUMBER(14, 2) | YES | ||
PD_18_RF_AMT | NUMBER(14, 2) | YES | ||
PD_18_DIF_AMT | NUMBER(14, 2) | YES | ||
PD_1_GL_HRS | NUMBER(14, 2) | YES | ||
PD_1_RF_HRS | NUMBER(14, 2) | YES | ||
PD_1_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_2_GL_HRS | NUMBER(14, 2) | YES | ||
PD_2_RF_HRS | NUMBER(14, 2) | YES | ||
PD_2_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_3_GL_HRS | NUMBER(14, 2) | YES | ||
PD_3_RF_HRS | NUMBER(14, 2) | YES | ||
PD_3_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_4_GL_HRS | NUMBER(14, 2) | YES | ||
PD_4_RF_HRS | NUMBER(14, 2) | YES | ||
PD_4_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_5_GL_HRS | NUMBER(14, 2) | YES | ||
PD_5_RF_HRS | NUMBER(14, 2) | YES | ||
PD_5_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_6_GL_HRS | NUMBER(14, 2) | YES | ||
PD_6_RF_HRS | NUMBER(14, 2) | YES | ||
PD_6_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_7_GL_HRS | NUMBER(14, 2) | YES | ||
PD_7_RF_HRS | NUMBER(14, 2) | YES | ||
PD_7_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_8_GL_HRS | NUMBER(14, 2) | YES | ||
PD_8_RF_HRS | NUMBER(14, 2) | YES | ||
PD_8_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_9_GL_HRS | NUMBER(14, 2) | YES | ||
PD_9_RF_HRS | NUMBER(14, 2) | YES | ||
PD_9_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_10_GL_HRS | NUMBER(14, 2) | YES | ||
PD_10_RF_HRS | NUMBER(14, 2) | YES | ||
PD_10_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_11_GL_HRS | NUMBER(14, 2) | YES | ||
PD_11_RF_HRS | NUMBER(14, 2) | YES | ||
PD_11_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_12_GL_HRS | NUMBER(14, 2) | YES | ||
PD_12_RF_HRS | NUMBER(14, 2) | YES | ||
PD_12_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_13_GL_HRS | NUMBER(14, 2) | YES | ||
PD_13_RF_HRS | NUMBER(14, 2) | YES | ||
PD_13_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_14_GL_HRS | NUMBER(14, 2) | YES | ||
PD_14_RF_HRS | NUMBER(14, 2) | YES | ||
PD_14_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_15_GL_HRS | NUMBER(14, 2) | YES | ||
PD_15_RF_HRS | NUMBER(14, 2) | YES | ||
PD_15_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_16_GL_HRS | NUMBER(14, 2) | YES | ||
PD_16_RF_HRS | NUMBER(14, 2) | YES | ||
PD_16_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_17_GL_HRS | NUMBER(14, 2) | YES | ||
PD_17_RF_HRS | NUMBER(14, 2) | YES | ||
PD_17_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_18_GL_HRS | NUMBER(14, 2) | YES | ||
PD_18_RF_HRS | NUMBER(14, 2) | YES | ||
PD_18_DIF_HRS | NUMBER(14, 2) | YES | ||
GLD_BEG_AMT | NUMBER(14, 2) | YES | ||
REF_BEG_AMT | NUMBER(14, 2) | YES | ||
DIF_BEG_AMT | NUMBER(14, 2) | YES | ||
GLD_BEG_HRS | NUMBER(14, 2) | YES | ||
REF_BEG_HRS | NUMBER(14, 2) | YES | ||
DIF_BEG_HRS | NUMBER(14, 2) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES |
Z_GLPUPRS_WRK1 Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_GLPUPRS_WRK1 Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |