Module: Work Asset Analytics
Type: Dimension
W1_FT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| W1_FT_ID | VARCHAR2 | 14 | True | Financial Transaction | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCEPTED_QTY | NUMBER | 13 | 5 | Accepted Quantity | |||
| ACCOUNT_SEGMENT | VARCHAR2 | 254 | Account Segment | ||||
| ACPT_LINE_ID | VARCHAR2 | 14 | Accept Line | ||||
| ACPT_LINE_STATUS_CD | VARCHAR2 | 12 | Accept Line Status | ||||
| ACPT_W1_QUANTITY | NUMBER | 13 | 5 | Accept Line Quantity | |||
| ACTIVITY_DESCR100 | VARCHAR2 | 100 | Activity Description | ||||
| ACTIVITY_DESCRLONG | VARCHAR2 | 4000 | Activity Detailed Description | ||||
| ACTVN_DTTM | TIMESTAMP | 0 | 6 | Activation Date/Time | |||
| ACT_DPOS_FLG | VARCHAR2 | 4 | Activity Disposition | ||||
| ACT_END_DT | DATE | 0 | End Date | ||||
| ACT_ID | VARCHAR2 | 14 | Asset Activity | ||||
| ACT_NUM | NUMBER | 5 | 0 | Activity Number | |||
| ACT_RECON_DESCR100 | VARCHAR2 | 100 | Activity Reconciliation Description | ||||
| ACT_RECON_ID | VARCHAR2 | 14 | Activity Reconciliation | ||||
| ACT_RECON_STATUS_CD | VARCHAR2 | 12 | Activity Reconciliation Status | ||||
| ACT_RESRC_REQMT_ID | VARCHAR2 | 14 | Activity Resource Requirement | ||||
| ACT_START_DT | DATE | 0 | Start Date | ||||
| ACT_STATUS_CD | VARCHAR2 | 12 | Activity Status | ||||
| ACT_TYPE_CD | VARCHAR2 | 30 | Asset Activity Type | ||||
| ACT_WORK_CATEGORY_CD | VARCHAR2 | 30 | Work Category - Activity | ||||
| ACT_WORK_CLASS_CD | VARCHAR2 | 30 | Work Class - Activity | ||||
| ADDER | NUMBER | 8 | 5 | Adder | |||
| ADJUSTED_SYSTEM_COUNT | NUMBER | 13 | 5 | Adjusted System Count | |||
| ALLOW_CHARGE_FLG | VARCHAR2 | 4 | Allow Charge | ||||
| AMT | NUMBER | 17 | 3 | Amount | |||
| ANNIVERSARY_DT | DATE | 0 | Anniversary Date | ||||
| ANNIVERSARY_VALUE | NUMBER | 18 | 7 | Anniversary Value | |||
| BACK_LOG_GRP_FLG | VARCHAR2 | 4 | Backlog Group | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| BUDGET_AMT | NUMBER | 17 | 3 | Budget Amount | |||
| CATEGORY_FLG | VARCHAR2 | 4 | Category | ||||
| CHARGE_TYPE_FLG | VARCHAR2 | 4 | Charge Type | ||||
| CH_DT | DATE | 0 | Other Direct Charges Detail Charge Date | ||||
| CH_TYPE | VARCHAR2 | 4 | Other Direct Charges Detail Charge Type | ||||
| COMPLIANCE_DATE | DATE | 0 | Compliance Date | ||||
| COMPLIANCE_UPD_DATE_RSN_FLG | VARCHAR2 | 4 | Compliance Date Update Reason | ||||
| CONSTR_RELATED_FLG | VARCHAR2 | 4 | Construction Related | ||||
| CREW_SHIFT_DIFF | NUMBER | 8 | 5 | Crew Shift Differential | |||
| CREW_SHIFT_TYPE_CD | VARCHAR2 | 30 | Crew Shift Type | ||||
| CREW_TYPE_CD | VARCHAR2 | 30 | Crew Type | ||||
| CURRENCY_CD | VARCHAR2 | 3 | Currency Code | ||||
| DELIVER_TO_LOC | VARCHAR2 | 12 | Deliver To Location | ||||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| DIFF_CALC_TYPE_FLG | VARCHAR2 | 4 | Differential Calculation Type | ||||
| EMERGENCY_FLG | VARCHAR2 | 4 | Emergency | ||||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| END_READING | NUMBER | 18 | 7 | End Reading | |||
| EST_END_DT | DATE | 0 | Estimated End Date | ||||
| EST_START_DT | DATE | 0 | Estimated Start Date | ||||
| EU_CLASS_FLG | VARCHAR2 | 4 | Employee Unavailability Class | ||||
| EU_TYPE_CD | VARCHAR2 | 30 | Employee Unavailability Type | ||||
| FIRST_COUNT | NUMBER | 13 | 5 | First Count | |||
| FT_STATUS_CD | VARCHAR2 | 12 | Financial Transaction Status | ||||
| HELD_FOR_PARTS_FLG | VARCHAR2 | 4 | Held For Parts | ||||
| HOURS | NUMBER | 13 | 2 | Hours | |||
| INVOICE_HEADER_ID | VARCHAR2 | 14 | Invoice Header | ||||
| INVOICE_LINE_ID | VARCHAR2 | 14 | Invoice Line | ||||
| INV_ADJ_ID | VARCHAR2 | 14 | Inventory Adjustment | ||||
| INV_ADJ_STATUS_CD | VARCHAR2 | 12 | Inventory Adjustment Status | ||||
| ISSUED_QTY | NUMBER | 13 | 5 | Issue Quantity | |||
| LABOR_EARNING_TYPE_CD | VARCHAR2 | 30 | Labor Earning Type | ||||
| MAT_DISP_ID | VARCHAR2 | 14 | Material Disposition | ||||
| MAT_ISS_LINE_ID | VARCHAR2 | 14 | Material Issue Line | ||||
| MAT_ISS_LINE_STATUS_CD | VARCHAR2 | 12 | Material Issue Line Status | ||||
| MAT_ISS_W1_TOTAL_COST | NUMBER | 17 | 3 | Material Issue Line Total Cost | |||
| MAT_RET_LINE_ID | VARCHAR2 | 14 | Material Return Line | ||||
| MAT_RET_LINE_STATUS_CD | VARCHAR2 | 12 | Material Return Line Status | ||||
| MAT_RET_W1_TOTAL_COST | NUMBER | 17 | 3 | Material Return Line Total Cost | |||
| MULTIPLIER | NUMBER | 8 | 5 | Multiplier | |||
| NEW_QTY | NUMBER | 13 | 5 | New Quantity | |||
| NEW_UNIT_PRICE | NUMBER | 18 | 7 | New Average Unit Price | |||
| NT_XID_CD | VARCHAR2 | 30 | External System | ||||
| ODC_DTL_ID | VARCHAR2 | 14 | Information | ||||
| ODC_DTL_STATUS_CD | VARCHAR2 | 12 | Other Direct Charges Detail Status | ||||
| ODC_DTL_UNIT_PRICE | NUMBER | 18 | 7 | Other Direct Charges Detail Unit Price | |||
| ODC_DTL_W1_TOTAL_COST | NUMBER | 17 | 3 | Other Direct Charges Detail Total Cost | |||
| ODC_W1_QUANTITY | NUMBER | 13 | 5 | Other Direct Charges Detail Quantity | |||
| OLD_QTY | NUMBER | 13 | 5 | Old Quantity | |||
| OLD_UNIT_PRICE | NUMBER | 18 | 7 | Old Average Unit Price | |||
| ORIGINAL_WORK_DT | DATE | 0 | Original Work Date | ||||
| OUTAGE_TYPE_FLG | VARCHAR2 | 4 | Outage Type | ||||
| OVERTIME_TYPE_CD | VARCHAR2 | 30 | Overtime Type | ||||
| PHASE_FLG | VARCHAR2 | 4 | Phase | ||||
| PI_CNT_LINE_ID | VARCHAR2 | 14 | Physical Inventory Count Line | ||||
| PI_CNT_LINE_STATUS_CD | VARCHAR2 | 12 | Physical Inventory Count Line Status | ||||
| PLANNING_HORIZON | NUMBER | 5 | 0 | Planning Horizon Days | |||
| PREM_RATE_MULTIPLIER | NUMBER | 8 | 5 | Premium Rate Multiplier | |||
| PRJ_ID | VARCHAR2 | 12 | Project | ||||
| PRJ_NUM | VARCHAR2 | 14 | Project Number | ||||
| PRJ_STATUS_CD | VARCHAR2 | 12 | Project Status | ||||
| PROJECT_DESCR100 | VARCHAR2 | 100 | Project Description | ||||
| PROJECT_DESCRLONG | VARCHAR2 | 4000 | Project Detailed Description | ||||
| REASON_CD_FLG | VARCHAR2 | 4 | Reason | ||||
| RECOUNT | NUMBER | 13 | 5 | Recount | |||
| RECOUNT_INDICATOR_FLG | VARCHAR2 | 4 | Recount Indicator | ||||
| REG_OVERTIME_FLG | VARCHAR2 | 4 | Regular/Overtime | ||||
| RENEWAL_FLG | VARCHAR2 | 4 | Service Class Type | ||||
| REPAIRED_FLG | VARCHAR2 | 4 | Repaired | ||||
| REQUESTOR_ID | VARCHAR2 | 8 | Requestor | ||||
| REQUIRED_BY_DT | DATE | 0 | Required By Date | ||||
| RESRC_UOM_CD | VARCHAR2 | 30 | Resource UOM | ||||
| RETURN_LINE_DESCR100 | VARCHAR2 | 100 | Return Line Description | ||||
| RETURN_QTY | NUMBER | 13 | 5 | Return Quantity | |||
| RTN_LINE_ID | VARCHAR2 | 14 | Return Line | ||||
| RTN_LINE_STATUS_CD | VARCHAR2 | 12 | Return Line Status | ||||
| RTN_W1_QUANTITY | NUMBER | 13 | 5 | Return Line Quantity | |||
| SCHEDULE_PERIOD_FLG | VARCHAR2 | 4 | Schedule Period | ||||
| SEQ_NUM | NUMBER | 3 | 0 | Sequence | |||
| SERVICE_CLASS_CD | VARCHAR2 | 30 | Service Class | ||||
| SIBLING_CANCELLED_FLG | VARCHAR2 | 4 | Is Sibling Cancelled? | ||||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| START_READING | NUMBER | 18 | 7 | Start Reading | |||
| START_TM | TIMESTAMP | 0 | 6 | Start Time | |||
| SYSTEM_COUNT | NUMBER | 13 | 5 | System Count | |||
| TIMESHEET_DETAIL_ID | VARCHAR2 | 14 | Timesheet Detail | ||||
| TIMESHEET_DTL_STATUS_CD | VARCHAR2 | 12 | Timesheet Detail Status | ||||
| TOTAL_PRIORITY | NUMBER | 2 | 0 | Total Risk Priority | |||
| TRAVEL_TIME | NUMBER | 9 | 0 | Travel Time | |||
| TYPE_OF_ADJUST_FLG | VARCHAR2 | 4 | Type of Adjustment | ||||
| TYPE_OF_INV_ADJ_FLG | VARCHAR2 | 4 | Type of Inventory Adjustment | ||||
| TYPE_OF_RTN_FLG | VARCHAR2 | 4 | Type of Return | ||||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| W1_ACCOUNTING_DT | DATE | 0 | Accounting Date | ||||
| W1_CREW_ID | VARCHAR2 | 12 | Crew | ||||
| W1_CREW_NAME | VARCHAR2 | 254 | Crew Name | ||||
| W1_DT | DATE | 0 | Charge Date | ||||
| W1_END_TM | TIMESTAMP | 0 | 6 | End Time | |||
| W1_FT_TYPE_FLG | VARCHAR2 | 4 | Financial Transaction Type | ||||
| W1_TOTAL_COST | NUMBER | 17 | 3 | Total Cost | |||
| WORK_PRIORITY_FLG | VARCHAR2 | 4 | Work Priority | ||||
| WORK_REQ_ID | VARCHAR2 | 14 | Work Request | ||||
| WORK_WIN_END_DTTM | TIMESTAMP | 0 | 6 | Work Window End Date/Time | |||
| WORK_WIN_START_DTTM | TIMESTAMP | 0 | 6 | Work Window Start Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |