RDM_CDTO_PPM_RESOURCES_HIST_V

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ID INTEGER 4
2 MUID CHARACTER VARYING(4000) 4000
3 VERSIONNAME NATIONAL CHARACTER VARYING(50) 50
4 VERSIONNUMBER INTEGER 4
5 VERSION_ID INTEGER 4
6 VERSIONFLAG NATIONAL CHARACTER VARYING(50) 50
7 NAME NATIONAL CHARACTER VARYING(250) 250
8 CODE NATIONAL CHARACTER VARYING(250) 250
9 CHANGETRACKINGMASK INTEGER 4
10 ACTIVE NATIONAL CHARACTER VARYING(10) 10
11 RESOURCE_NAME NATIONAL CHARACTER VARYING(100) 100
12 SUNCORP_RESOURCE_ID NATIONAL CHARACTER VARYING(10) 10
13 RESOURCE_POSITION_ID NATIONAL CHARACTER VARYING(10) 10
14 ROLE NATIONAL CHARACTER VARYING(100) 100
15 EMPLOYMENT_TYPE NATIONAL CHARACTER VARYING(50) 50
16 BAU_ALLOCATION_PERCENTAGE NUMERIC(31,0) 19
17 MAX_UNITS NUMERIC(31,2) 19
18 TIMESHEET_MANAGER NATIONAL CHARACTER VARYING(100) 100
19 HR_LEADER NATIONAL CHARACTER VARYING(100) 100
20 BOOKING_TYPE NATIONAL CHARACTER VARYING(100) 100
21 COST_CENTER NATIONAL CHARACTER VARYING(5) 5
22 COST_TYPE NATIONAL CHARACTER VARYING(100) 100
23 GL_CODE NATIONAL CHARACTER VARYING(100) 100
24 BASE_CALENDAR NATIONAL CHARACTER VARYING(100) 100
25 LOCATION_RATE NATIONAL CHARACTER VARYING(100) 100
26 EARLIEST_AVAILABLE NATIONAL CHARACTER VARYING(10) 10
27 RESOURCE_START_DATE NATIONAL CHARACTER VARYING(10) 10
28 RESOURCE_END_DATE NATIONAL CHARACTER VARYING(10) 10
29 RESOURCE_LOCATION NATIONAL CHARACTER VARYING(100) 100
30 BUDGET_FUNCTION NATIONAL CHARACTER VARYING(10) 10
31 RESOURCE_DEPARTMENTS NATIONAL CHARACTER VARYING(10) 10
32 TDL_FUNCTION NATIONAL CHARACTER VARYING(20) 20
33 RESOURCE_SUB_DOMAIN NATIONAL CHARACTER VARYING(100) 100
34 RESOURCE_PORTFOLIO NATIONAL CHARACTER VARYING(100) 100
35 OBS NATIONAL CHARACTER VARYING(175) 175
36 INVOICE_DAILY_RATE NUMERIC(31,0) 19
37 STANDARD_RATE NATIONAL CHARACTER VARYING(100) 100
38 SUPPLIER NATIONAL CHARACTER VARYING(100) 100
39 TIMESHEET NATIONAL CHARACTER VARYING(10) 10
40 CAPACITY_PLANNING NATIONAL CHARACTER VARYING(10) 10
41 DEFAULT_ASSIGNMENT_OWNER NATIONAL CHARACTER VARYING(100) 100
42 EMAIL_ADDRESS NATIONAL CHARACTER VARYING(100) 100
43 RESOURCE_NOTES NATIONAL CHARACTER VARYING(100) 100
44 LAST_MODIFIED NATIONAL CHARACTER VARYING(10) 10
45 ENTERDATETIME TIMESTAMP 8
46 ENTERUSERNAME NATIONAL CHARACTER VARYING(100) 100
47 ENTERVERSIONNUMBER INTEGER 4
48 LASTCHGDATETIME TIMESTAMP 8
49 LASTCHGUSERNAME NATIONAL CHARACTER VARYING(100) 100
50 LASTCHGVERSIONNUMBER INTEGER 4
51 VALIDATIONSTATUS NATIONAL CHARACTER VARYING(250) 250
52 CDC_SRC_SYSTEM_CODE CHARACTER(4) 4
53 CDC_RECORD_TYPE CHARACTER(14) 14
54 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
55 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8