Module: Work Asset Analytics
Type: Dimension
W1_TIMESHEET_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| W1_TIMESHEET_ID | VARCHAR2 | 14 | True | Timesheet | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ADDRESS1 | VARCHAR2 | 254 | Address | ||||
| ADDRESS2 | VARCHAR2 | 254 | Address 2 | ||||
| ADDRESS3 | VARCHAR2 | 254 | Address 3 | ||||
| ADDRESS4 | VARCHAR2 | 254 | Address 4 | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| CITY | VARCHAR2 | 90 | City | ||||
| COUNTRY | VARCHAR2 | 3 | Country | ||||
| COUNTY | VARCHAR2 | 90 | County | ||||
| EMPLOYEE_ID | VARCHAR2 | 12 | Employee | ||||
| GEO_CODE | VARCHAR2 | 11 | Geographical Code | ||||
| HIRED_DT | DATE | 0 | Hire Date | ||||
| HOUSE_TYPE | VARCHAR2 | 2 | House Type | ||||
| IN_CITY_LIMIT | VARCHAR2 | 1 | In City Limit | ||||
| JOB_TITLE | VARCHAR2 | 254 | Job Title | ||||
| NUM1 | VARCHAR2 | 6 | Number 1 | ||||
| NUM2 | VARCHAR2 | 4 | Number 2 | ||||
| POSTAL | VARCHAR2 | 12 | Postal | ||||
| STATE | VARCHAR2 | 6 | State | ||||
| TERMINATED_DT | DATE | 0 | Termination Date | ||||
| TIME_PERIOD_CD | VARCHAR2 | 30 | Time Period | ||||
| W1_CROSS_STREET | VARCHAR2 | 64 | Cross Street | ||||
| W1_FIRST_NAME | VARCHAR2 | 254 | First Name | ||||
| W1_GEO_LAT | NUMBER | 15 | 6 | Latitude | |||
| W1_GEO_LONG | NUMBER | 15 | 6 | Longitude | |||
| W1_LAST_NAME | VARCHAR2 | 254 | Last Name | ||||
| W1_SUBURB | VARCHAR2 | 64 | Suburb | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |