Period

Entity Relationship Diagram

Tip:   

Right click the attachment to view Entity Relationship Diagram for Period in a new tab.

List of Objects

DB Object Name Object Business Name Object Description DB Attribute Name Attribute Business Name Ordinal Position Data Type Name Data Type Size Numeric Scale Is Identity Is Nullable Primary Key Mandatory
PERIOD_DT_C Period Date Period Date PRD_DT_SYS_KEY_C PRD DT SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
PERIOD_DT_C Period Date Period Date DT_STYL101_VAL_C DT STYL101 VAL C 2 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL102_VAL_C DT STYL102 VAL C 3 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL103_VAL_C DT STYL103 VAL C 4 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL104_VAL_C DT STYL104 VAL C 5 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL105_VAL_C DT STYL105 VAL C 6 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL110_VAL_C DT STYL110 VAL C 7 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL111_VAL_C DT STYL111 VAL C 8 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DT_STYL112_VAL_C DT STYL112 VAL C 9 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DAY_NUM_C DAY NUM C 10 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date DAY_NM_C DAY NM C 11 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MTH_NUM_C MTH NUM C 12 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MTH_ABBR_NM_C MTH ABBR NM C 13 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MTH_FULL_NM_C MTH FULL NM C 14 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date QTR_NUM_C QTR NUM C 15 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date QTR_NM_C QTR NM C 16 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date YR_NUM_C YR NUM C 17 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MMYYYY_NUM_C MMYYYY NUM C 18 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MMYYYY_NM_C MMYYYY NM C 19 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date WK_STRTMONDAY_DT_C WK STRTMONDAY DT C 20 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date WK_ENDFRIDAY_DT_C WK ENDFRIDAY DT C 21 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date WK_ENDSUNDAY_DT_C WK ENDSUNDAY DT C 22 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MTH_FRSTDAY_DT_C MTH FRSTDAY DT C 23 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date MTH_LSTDAY_DT_C MTH LSTDAY DT C 24 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date QTR_FRSTDAY_DT_C QTR FRSTDAY DT C 25 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date QTR_LSTDAY_DT_C QTR LSTDAY DT C 26 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date YR_FRSTDAY_DT_C YR FRSTDAY DT C 27 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date YR_LSTDAY_DT_C YR LSTDAY DT C 28 DATE     NO YES FALSE FALSE
PERIOD_DT_C Period Date Period Date PERIOD_MTH_SYS_KEY_C PERIOD MTH SYS KEY C 29 VARCHAR 16777216   NO NO FALSE TRUE
PERIOD_DT_C Period Date Period Date PERIOD_QTR_SYS_KEY_C PERIOD QTR SYS KEY C 30 VARCHAR 16777216   NO NO FALSE TRUE
PERIOD_MTH_C Period Month Period Month PRD_MTH_SYS_KEY_C PRD MTH SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
PERIOD_MTH_C Period Month Period Month MTH_NUM_C MTH NUM C 2 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month MTH_ABBR_NM_C MTH ABBR NM C 3 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month MTH_FULL_NM_C MTH FULL NM C 4 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month QTR_NUM_C QTR NUM C 5 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month QTR_NM_C QTR NM C 6 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month YR_NUM_C YR NUM C 7 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month MMYYYY_NUM_C MMYYYY NUM C 8 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month MMYYYY_NM_C MMYYYY NM C 9 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month MTH_FRSTDAY_DT_C MTH FRSTDAY DT C 10 DATE     NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month MTH_LSTDAY_DT_C MTH LSTDAY DT C 11 DATE     NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month QTR_FRSTDAY_DT_C QTR FRSTDAY DT C 12 DATE     NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month QTR_LSTDAY_DT_C QTR LSTDAY DT C 13 DATE     NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month YR_FRSTDAY_DT_C YR FRSTDAY DT C 14 DATE     NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month YR_LSTDAY_DT_C YR LSTDAY DT C 15 DATE     NO YES FALSE FALSE
PERIOD_MTH_C Period Month Period Month PERIOD_QTR_SYS_KEY_C PERIOD QTR SYS KEY C 16 VARCHAR 16777216   NO NO FALSE TRUE
PERIOD_QTR_C Period Quarter Period Quarter PRD_QTR_SYS_KEY_C PRD QTR SYS KEY C 1 VARCHAR 16777216   NO NO TRUE TRUE
PERIOD_QTR_C Period Quarter Period Quarter QTR_NUM_C QTR NUM C 2 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_QTR_C Period Quarter Period Quarter QTR_NM_C QTR NM C 3 VARCHAR 16777216   NO YES FALSE FALSE
PERIOD_QTR_C Period Quarter Period Quarter YR_NUM_C YR NUM C 4 NUMERIC 38 0 NO YES FALSE FALSE
PERIOD_QTR_C Period Quarter Period Quarter QTR_FRSTDAY_DT_C QTR FRSTDAY DT C 5 DATE     NO YES FALSE FALSE
PERIOD_QTR_C Period Quarter Period Quarter QTR_LSTDAY_DT_C QTR LSTDAY DT C 6 DATE     NO YES FALSE FALSE
PERIOD_QTR_C Period Quarter Period Quarter YR_FRSTDAY_DT_C YR FRSTDAY DT C 7 DATE     NO YES FALSE FALSE
PERIOD_QTR_C Period Quarter Period Quarter YR_LSTDAY_DT_C YR LSTDAY DT C 8 DATE     NO YES FALSE FALSE