TM1_FTE_FORECASTS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FTE_VERSION CHARACTER VARYING(30) 30
2 FTE_MONTH CHARACTER VARYING(10) 10
3 ACTIVITY_CENTRE CHARACTER VARYING(10) 10
4 HR_MEASURE CHARACTER VARYING(30) 30
5 EMPLOYEE_CLASS CHARACTER VARYING(30) 30
6 TM1_FTE_FORECASTS_VALUE DOUBLE PRECISION 8
7 DATA_DATE TIMESTAMP 8
8 LOAD_ID INTEGER 4
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8