Z_GLPUPFS_WRK |
Default Table Name | Z_GLPUPFS_WRK |
Definition |
Z_GLPUPFS_WRK Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ACCT_ID | VARCHAR2(15) | YES | ||
ORG_ID | VARCHAR2(20) | YES | ||
FY_CD | VARCHAR2(6) | YES | ||
PD_1_GL_AMT | NUMBER(17, 2) | YES | ||
PD_1_FS_AMT | NUMBER(17, 2) | YES | ||
PD_1_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_2_GL_AMT | NUMBER(17, 2) | YES | ||
PD_2_FS_AMT | NUMBER(17, 2) | YES | ||
PD_2_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_3_GL_AMT | NUMBER(17, 2) | YES | ||
PD_3_FS_AMT | NUMBER(17, 2) | YES | ||
PD_3_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_4_GL_AMT | NUMBER(17, 2) | YES | ||
PD_4_FS_AMT | NUMBER(17, 2) | YES | ||
PD_4_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_5_GL_AMT | NUMBER(17, 2) | YES | ||
PD_5_FS_AMT | NUMBER(17, 2) | YES | ||
PD_5_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_6_GL_AMT | NUMBER(17, 2) | YES | ||
PD_6_FS_AMT | NUMBER(17, 2) | YES | ||
PD_6_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_7_GL_AMT | NUMBER(17, 2) | YES | ||
PD_7_FS_AMT | NUMBER(17, 2) | YES | ||
PD_7_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_8_GL_AMT | NUMBER(17, 2) | YES | ||
PD_8_FS_AMT | NUMBER(17, 2) | YES | ||
PD_8_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_9_GL_AMT | NUMBER(17, 2) | YES | ||
PD_9_FS_AMT | NUMBER(17, 2) | YES | ||
PD_9_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_10_GL_AMT | NUMBER(17, 2) | YES | ||
PD_10_FS_AMT | NUMBER(17, 2) | YES | ||
PD_10_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_11_GL_AMT | NUMBER(17, 2) | YES | ||
PD_11_FS_AMT | NUMBER(17, 2) | YES | ||
PD_11_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_12_GL_AMT | NUMBER(17, 2) | YES | ||
PD_12_FS_AMT | NUMBER(17, 2) | YES | ||
PD_12_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_13_GL_AMT | NUMBER(17, 2) | YES | ||
PD_13_FS_AMT | NUMBER(17, 2) | YES | ||
PD_13_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_14_GL_AMT | NUMBER(17, 2) | YES | ||
PD_14_FS_AMT | NUMBER(17, 2) | YES | ||
PD_14_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_15_GL_AMT | NUMBER(17, 2) | YES | ||
PD_15_FS_AMT | NUMBER(17, 2) | YES | ||
PD_15_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_16_GL_AMT | NUMBER(17, 2) | YES | ||
PD_16_FS_AMT | NUMBER(17, 2) | YES | ||
PD_16_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_17_GL_AMT | NUMBER(17, 2) | YES | ||
PD_17_FS_AMT | NUMBER(17, 2) | YES | ||
PD_17_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_18_GL_AMT | NUMBER(17, 2) | YES | ||
PD_18_FS_AMT | NUMBER(17, 2) | YES | ||
PD_18_DIF_AMT | NUMBER(17, 2) | YES | ||
PD_1_GL_HRS | NUMBER(14, 2) | YES | ||
PD_1_FS_HRS | NUMBER(14, 2) | YES | ||
PD_1_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_2_GL_HRS | NUMBER(14, 2) | YES | ||
PD_2_FS_HRS | NUMBER(14, 2) | YES | ||
PD_2_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_3_GL_HRS | NUMBER(14, 2) | YES | ||
PD_3_FS_HRS | NUMBER(14, 2) | YES | ||
PD_3_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_4_GL_HRS | NUMBER(14, 2) | YES | ||
PD_4_FS_HRS | NUMBER(14, 2) | YES | ||
PD_4_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_5_GL_HRS | NUMBER(14, 2) | YES | ||
PD_5_FS_HRS | NUMBER(14, 2) | YES | ||
PD_5_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_6_GL_HRS | NUMBER(14, 2) | YES | ||
PD_6_FS_HRS | NUMBER(14, 2) | YES | ||
PD_6_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_7_GL_HRS | NUMBER(14, 2) | YES | ||
PD_7_FS_HRS | NUMBER(14, 2) | YES | ||
PD_7_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_8_GL_HRS | NUMBER(14, 2) | YES | ||
PD_8_FS_HRS | NUMBER(14, 2) | YES | ||
PD_8_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_9_GL_HRS | NUMBER(14, 2) | YES | ||
PD_9_FS_HRS | NUMBER(14, 2) | YES | ||
PD_9_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_10_GL_HRS | NUMBER(14, 2) | YES | ||
PD_10_FS_HRS | NUMBER(14, 2) | YES | ||
PD_10_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_11_GL_HRS | NUMBER(14, 2) | YES | ||
PD_11_FS_HRS | NUMBER(14, 2) | YES | ||
PD_11_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_12_GL_HRS | NUMBER(14, 2) | YES | ||
PD_12_FS_HRS | NUMBER(14, 2) | YES | ||
PD_12_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_13_GL_HRS | NUMBER(14, 2) | YES | ||
PD_13_FS_HRS | NUMBER(14, 2) | YES | ||
PD_13_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_14_GL_HRS | NUMBER(14, 2) | YES | ||
PD_14_FS_HRS | NUMBER(14, 2) | YES | ||
PD_14_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_15_GL_HRS | NUMBER(14, 2) | YES | ||
PD_15_FS_HRS | NUMBER(14, 2) | YES | ||
PD_15_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_16_GL_HRS | NUMBER(14, 2) | YES | ||
PD_16_FS_HRS | NUMBER(14, 2) | YES | ||
PD_16_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_17_GL_HRS | NUMBER(14, 2) | YES | ||
PD_17_FS_HRS | NUMBER(14, 2) | YES | ||
PD_17_DIF_HRS | NUMBER(14, 2) | YES | ||
PD_18_GL_HRS | NUMBER(14, 2) | YES | ||
PD_18_FS_HRS | NUMBER(14, 2) | YES | ||
PD_18_DIF_HRS | NUMBER(14, 2) | YES | ||
GLP_BEG_AMT | NUMBER(17, 2) | YES | ||
FS_BEG_AMT | NUMBER(17, 2) | YES | ||
DIF_BEG_AMT | NUMBER(17, 2) | YES | ||
GLP_BEG_HRS | NUMBER(14, 2) | YES | ||
FS_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_GLPUPFS_WRK Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_GLPUPFS_WRK 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 |