EREPORT_PROJ_TREND |
Default Table Name | EREPORT_PROJ_TREND |
Definition |
EREPORT_PROJ_TREND Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ROW_UID | VARCHAR2(36) | NO | ||
PROJ_ID | VARCHAR2(50) | YES | ||
NB_PROJ_ID | VARCHAR2(50) | YES | ||
ID | VARCHAR2(50) | YES | ||
ORG_ID | VARCHAR2(50) | YES | ||
ACCT_ID | VARCHAR2(15) | YES | ||
MAJOR_GRP_NO | NUMBER(10, 0) | YES | ||
MAJOR_GRP_DESC | VARCHAR2(50) | YES | ||
MINOR_GRP_NO | NUMBER(10, 0) | YES | ||
MINOR_GRP_DESC | VARCHAR2(50) | YES | ||
SHEET_NO | NUMBER(10, 0) | YES | ||
SHEET_DESC | VARCHAR2(25) | YES | ||
LINE_ID | VARCHAR2(50) | YES | ||
LINE_NAME | VARCHAR2(102) | YES | ||
BILL_LAB_CAT_CD | VARCHAR2(10) | YES | ||
SOURCE | VARCHAR2(10) | YES | ||
RESOURCE_TYPE | VARCHAR2(1) | YES | ||
EMPL_ID | VARCHAR2(50) | YES | ||
VEND_ID | VARCHAR2(50) | YES | ||
GENSTF_ID | VARCHAR2(50) | YES | ||
BUD_TYPE | VARCHAR2(10) | YES | ||
BUD_VERSION | NUMBER(10, 0) | YES | ||
BUD_STATUS | VARCHAR2(25) | YES | ||
POOL_NO | NUMBER(10, 0) | YES | ||
POOL_FY | VARCHAR2(6) | YES | ||
CUR_PED | VARCHAR2(10) | YES | ||
CUR_ACT_AMT | NUMBER(20, 4) | YES | ||
CUR_ACT_HRS | NUMBER(20, 4) | YES | ||
YTD_ACT_AMT | NUMBER(20, 4) | YES | ||
YTD_ACT_HRS | NUMBER(20, 4) | YES | ||
ITD_ACT_AMT | NUMBER(20, 4) | YES | ||
ITD_ACT_HRS | NUMBER(20, 4) | YES | ||
CUR_ACT_BURD_AMT | NUMBER(20, 4) | YES | ||
CUR_TGT_BURD_AMT | NUMBER(20, 4) | YES | ||
YTD_ACT_BURD_AMT | NUMBER(20, 4) | YES | ||
YTD_TGT_BURD_AMT | NUMBER(20, 4) | YES | ||
ITD_ACT_BURD_AMT | NUMBER(20, 4) | YES | ||
ITD_TGT_BURD_AMT | NUMBER(20, 4) | YES | ||
CUR_ACT_REV_AMT | NUMBER(20, 4) | YES | ||
CUR_TGT_REV_AMT | NUMBER(20, 4) | YES | ||
YTD_ACT_REV_AMT | NUMBER(20, 4) | YES | ||
YTD_TGT_REV_AMT | NUMBER(20, 4) | YES | ||
ITD_ACT_REV_AMT | NUMBER(20, 4) | YES | ||
ITD_TGT_REV_AMT | NUMBER(20, 4) | YES | ||
ETC_AMT | NUMBER(20, 4) | YES | ||
ETC_HRS | NUMBER(20, 4) | YES | ||
ETC_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC_REV_AMT | NUMBER(20, 4) | YES | ||
ETC1_AMT | NUMBER(20, 4) | YES | ||
ETC1_HRS | NUMBER(20, 4) | YES | ||
ETC1_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC1_REV_AMT | NUMBER(20, 4) | YES | ||
ETC2_AMT | NUMBER(20, 4) | YES | ||
ETC2_HRS | NUMBER(20, 4) | YES | ||
ETC2_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC2_REV_AMT | NUMBER(20, 4) | YES | ||
ETC3_AMT | NUMBER(20, 4) | YES | ||
ETC3_HRS | NUMBER(20, 4) | YES | ||
ETC3_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC3_REV_AMT | NUMBER(20, 4) | YES | ||
ETC4_AMT | NUMBER(20, 4) | YES | ||
ETC4_HRS | NUMBER(20, 4) | YES | ||
ETC4_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC4_REV_AMT | NUMBER(20, 4) | YES | ||
ETC5_AMT | NUMBER(20, 4) | YES | ||
ETC5_HRS | NUMBER(20, 4) | YES | ||
ETC5_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC5_REV_AMT | NUMBER(20, 4) | YES | ||
ETC6_AMT | NUMBER(20, 4) | YES | ||
ETC6_HRS | NUMBER(20, 4) | YES | ||
ETC6_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC6_REV_AMT | NUMBER(20, 4) | YES | ||
ETC7_AMT | NUMBER(20, 4) | YES | ||
ETC7_HRS | NUMBER(20, 4) | YES | ||
ETC7_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC7_REV_AMT | NUMBER(20, 4) | YES | ||
ETC8_AMT | NUMBER(20, 4) | YES | ||
ETC8_HRS | NUMBER(20, 4) | YES | ||
ETC8_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC8_REV_AMT | NUMBER(20, 4) | YES | ||
ETC9_AMT | NUMBER(20, 4) | YES | ||
ETC9_HRS | NUMBER(20, 4) | YES | ||
ETC9_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC9_REV_AMT | NUMBER(20, 4) | YES | ||
ETC10_AMT | NUMBER(20, 4) | YES | ||
ETC10_HRS | NUMBER(20, 4) | YES | ||
ETC10_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC10_REV_AMT | NUMBER(20, 4) | YES | ||
ETC11_AMT | NUMBER(20, 4) | YES | ||
ETC11_HRS | NUMBER(20, 4) | YES | ||
ETC11_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC11_REV_AMT | NUMBER(20, 4) | YES | ||
ETC12_AMT | NUMBER(20, 4) | YES | ||
ETC12_HRS | NUMBER(20, 4) | YES | ||
ETC12_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC12_REV_AMT | NUMBER(20, 4) | YES | ||
ETC13_AMT | NUMBER(20, 4) | YES | ||
ETC13_HRS | NUMBER(20, 4) | YES | ||
ETC13_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC13_REV_AMT | NUMBER(20, 4) | YES | ||
ETC14_AMT | NUMBER(20, 4) | YES | ||
ETC14_HRS | NUMBER(20, 4) | YES | ||
ETC14_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC14_REV_AMT | NUMBER(20, 4) | YES | ||
ETC15_AMT | NUMBER(20, 4) | YES | ||
ETC15_HRS | NUMBER(20, 4) | YES | ||
ETC15_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC15_REV_AMT | NUMBER(20, 4) | YES | ||
ETC16_AMT | NUMBER(20, 4) | YES | ||
ETC16_HRS | NUMBER(20, 4) | YES | ||
ETC16_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC16_REV_AMT | NUMBER(20, 4) | YES | ||
ETC17_AMT | NUMBER(20, 4) | YES | ||
ETC17_HRS | NUMBER(20, 4) | YES | ||
ETC17_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC17_REV_AMT | NUMBER(20, 4) | YES | ||
ETC18_AMT | NUMBER(20, 4) | YES | ||
ETC18_HRS | NUMBER(20, 4) | YES | ||
ETC18_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC18_REV_AMT | NUMBER(20, 4) | YES | ||
ETC19_AMT | NUMBER(20, 4) | YES | ||
ETC19_HRS | NUMBER(20, 4) | YES | ||
ETC19_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC19_REV_AMT | NUMBER(20, 4) | YES | ||
ETC20_AMT | NUMBER(20, 4) | YES | ||
ETC20_HRS | NUMBER(20, 4) | YES | ||
ETC20_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC20_REV_AMT | NUMBER(20, 4) | YES | ||
ETC21_AMT | NUMBER(20, 4) | YES | ||
ETC21_HRS | NUMBER(20, 4) | YES | ||
ETC21_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC21_REV_AMT | NUMBER(20, 4) | YES | ||
ETC22_AMT | NUMBER(20, 4) | YES | ||
ETC22_HRS | NUMBER(20, 4) | YES | ||
ETC22_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC22_REV_AMT | NUMBER(20, 4) | YES | ||
ETC23_AMT | NUMBER(20, 4) | YES | ||
ETC23_HRS | NUMBER(20, 4) | YES | ||
ETC23_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC23_REV_AMT | NUMBER(20, 4) | YES | ||
ETC24_AMT | NUMBER(20, 4) | YES | ||
ETC24_HRS | NUMBER(20, 4) | YES | ||
ETC24_BURD_AMT | NUMBER(20, 4) | YES | ||
ETC24_REV_AMT | NUMBER(20, 4) | YES | ||
BUD_AMT | NUMBER(20, 4) | YES | ||
BUD_HRS | NUMBER(20, 4) | YES | ||
BUD_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD_REV_AMT | NUMBER(20, 4) | YES | ||
BUD1_AMT | NUMBER(20, 4) | YES | ||
BUD1_HRS | NUMBER(20, 4) | YES | ||
BUD1_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD1_REV_AMT | NUMBER(20, 4) | YES | ||
BUD2_AMT | NUMBER(20, 4) | YES | ||
BUD2_HRS | NUMBER(20, 4) | YES | ||
BUD2_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD2_REV_AMT | NUMBER(20, 4) | YES | ||
BUD3_AMT | NUMBER(20, 4) | YES | ||
BUD3_HRS | NUMBER(20, 4) | YES | ||
BUD3_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD3_REV_AMT | NUMBER(20, 4) | YES | ||
BUD4_AMT | NUMBER(20, 4) | YES | ||
BUD4_HRS | NUMBER(20, 4) | YES | ||
BUD4_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD4_REV_AMT | NUMBER(20, 4) | YES | ||
BUD5_AMT | NUMBER(20, 4) | YES | ||
BUD5_HRS | NUMBER(20, 4) | YES | ||
BUD5_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD5_REV_AMT | NUMBER(20, 4) | YES | ||
BUD6_AMT | NUMBER(20, 4) | YES | ||
BUD6_HRS | NUMBER(20, 4) | YES | ||
BUD6_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD6_REV_AMT | NUMBER(20, 4) | YES | ||
BUD7_AMT | NUMBER(20, 4) | YES | ||
BUD7_HRS | NUMBER(20, 4) | YES | ||
BUD7_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD7_REV_AMT | NUMBER(20, 4) | YES | ||
BUD8_AMT | NUMBER(20, 4) | YES | ||
BUD8_HRS | NUMBER(20, 4) | YES | ||
BUD8_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD8_REV_AMT | NUMBER(20, 4) | YES | ||
BUD9_AMT | NUMBER(20, 4) | YES | ||
BUD9_HRS | NUMBER(20, 4) | YES | ||
BUD9_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD9_REV_AMT | NUMBER(20, 4) | YES | ||
BUD10_AMT | NUMBER(20, 4) | YES | ||
BUD10_HRS | NUMBER(20, 4) | YES | ||
BUD10_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD10_REV_AMT | NUMBER(20, 4) | YES | ||
BUD11_AMT | NUMBER(20, 4) | YES | ||
BUD11_HRS | NUMBER(20, 4) | YES | ||
BUD11_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD11_REV_AMT | NUMBER(20, 4) | YES | ||
BUD12_AMT | NUMBER(20, 4) | YES | ||
BUD12_HRS | NUMBER(20, 4) | YES | ||
BUD12_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD12_REV_AMT | NUMBER(20, 4) | YES | ||
BUD13_AMT | NUMBER(20, 4) | YES | ||
BUD13_HRS | NUMBER(20, 4) | YES | ||
BUD13_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD13_REV_AMT | NUMBER(20, 4) | YES | ||
BUD14_AMT | NUMBER(20, 4) | YES | ||
BUD14_HRS | NUMBER(20, 4) | YES | ||
BUD14_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD14_REV_AMT | NUMBER(20, 4) | YES | ||
BUD15_AMT | NUMBER(20, 4) | YES | ||
BUD15_HRS | NUMBER(20, 4) | YES | ||
BUD15_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD15_REV_AMT | NUMBER(20, 4) | YES | ||
BUD16_AMT | NUMBER(20, 4) | YES | ||
BUD16_HRS | NUMBER(20, 4) | YES | ||
BUD16_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD16_REV_AMT | NUMBER(20, 4) | YES | ||
BUD17_AMT | NUMBER(20, 4) | YES | ||
BUD17_HRS | NUMBER(20, 4) | YES | ||
BUD17_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD17_REV_AMT | NUMBER(20, 4) | YES | ||
BUD18_AMT | NUMBER(20, 4) | YES | ||
BUD18_HRS | NUMBER(20, 4) | YES | ||
BUD18_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD18_REV_AMT | NUMBER(20, 4) | YES | ||
BUD19_AMT | NUMBER(20, 4) | YES | ||
BUD19_HRS | NUMBER(20, 4) | YES | ||
BUD19_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD19_REV_AMT | NUMBER(20, 4) | YES | ||
BUD20_AMT | NUMBER(20, 4) | YES | ||
BUD20_HRS | NUMBER(20, 4) | YES | ||
BUD20_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD20_REV_AMT | NUMBER(20, 4) | YES | ||
BUD21_AMT | NUMBER(20, 4) | YES | ||
BUD21_HRS | NUMBER(20, 4) | YES | ||
BUD21_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD21_REV_AMT | NUMBER(20, 4) | YES | ||
BUD22_AMT | NUMBER(20, 4) | YES | ||
BUD22_HRS | NUMBER(20, 4) | YES | ||
BUD22_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD22_REV_AMT | NUMBER(20, 4) | YES | ||
BUD23_AMT | NUMBER(20, 4) | YES | ||
BUD23_HRS | NUMBER(20, 4) | YES | ||
BUD23_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD23_REV_AMT | NUMBER(20, 4) | YES | ||
BUD24_AMT | NUMBER(20, 4) | YES | ||
BUD24_HRS | NUMBER(20, 4) | YES | ||
BUD24_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD24_REV_AMT | NUMBER(20, 4) | YES | ||
PO_AMT | NUMBER(20, 4) | YES | ||
PO_HRS | NUMBER(20, 4) | YES | ||
PO_BURD_AMT | NUMBER(20, 4) | YES | ||
EAC_AMT | NUMBER(20, 4) | YES | ||
EAC_HRS | NUMBER(20, 4) | YES | ||
EAC_BURD_AMT | NUMBER(20, 4) | YES | ||
EAC_REV_AMT | NUMBER(20, 4) | YES | ||
BUD_TOT_AMT | NUMBER(20, 4) | YES | ||
BUD_TOT_HRS | NUMBER(20, 4) | YES | ||
BUD_TOT_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD_TOT_REV_AMT | NUMBER(20, 4) | YES | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
MODIFIED_BY | VARCHAR2(50) | NO | ||
TIME_STAMP | DATE | NO | ||
PO_REV_AMT | NUMBER(20, 4) | YES | ||
CHRG_DT | DATE | YES | ||
BUD_YTD_AMT | NUMBER(20, 4) | YES | ||
BUD_YTD_HRS | NUMBER(20, 4) | YES | ||
BUD_YTD_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD_YTD_REV_AMT | NUMBER(20, 4) | YES | ||
BUD_ITD_AMT | NUMBER(20, 4) | YES | ||
BUD_ITD_HRS | NUMBER(20, 4) | YES | ||
BUD_ITD_BURD_AMT | NUMBER(20, 4) | YES | ||
BUD_ITD_REV_AMT | NUMBER(20, 4) | YES | ||
EAC_YTD_AMT | NUMBER(20, 4) | YES | ||
EAC_YTD_HRS | NUMBER(20, 4) | YES | ||
EAC_YTD_BURD_AMT | NUMBER(20, 4) | YES | ||
EAC_YTD_REV_AMT | NUMBER(20, 4) | YES | ||
EAC_ITD_AMT | NUMBER(20, 4) | YES | ||
EAC_ITD_HRS | NUMBER(20, 4) | YES | ||
EAC_ITD_BURD_AMT | NUMBER(20, 4) | YES | ||
EAC_ITD_REV_AMT | NUMBER(20, 4) | YES | ||
POOL_ORG_ID | VARCHAR2(50) | YES | ||
COMPANY_ID | VARCHAR2(10) | YES | ||
PRIOR_24_ACT_REV_AMT | NUMBER(20, 4) | YES | ||
PRIOR_24_TGT_REV_AMT | NUMBER(20, 4) | YES | ||
PRIOR_24_ACT_AMT | NUMBER(20, 4) | YES | ||
PRIOR_24_ACT_HRS | NUMBER(20, 4) | YES | ||
PRIOR_24_ACT_BURD_AMT | NUMBER(20, 4) | YES | ||
PRIOR_24_TGT_BURD_AMT | NUMBER(20, 4) | YES | ||
VEND_EMPL_ID | VARCHAR2(50) | YES | ||
BGT_VER_ID | VARCHAR2(3) | YES | ||
FINAL_VER | VARCHAR2(1) | YES | ||
LAST_CLOSED_PERIOD | DATE | YES |
EREPORT_PROJ_TREND Primary and Unique Keys |
Key Name | Key Type | Keys |
EREPORT_PROJ_TREND 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 |