Module: Work Asset Analytics
Type: Dimension
TMPL_ACT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TMPL_ACT_ID | VARCHAR2 | 12 | True | Template Activity | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACCOUNT_SEGMENT | VARCHAR2 | 254 | Account Segment | ||||
| ACT_END_DT | DATE | 0 | End Date | ||||
| ACT_START_DT | DATE | 0 | Start Date | ||||
| ALLOW_CHARGE_FLG | VARCHAR2 | 4 | Allow Charge | ||||
| BACK_LOG_GRP_FLG | VARCHAR2 | 4 | Backlog Group | ||||
| BUDGET_AMT | NUMBER | 17 | 3 | Budget Amount | |||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| EST_END_DT | DATE | 0 | Estimated End Date | ||||
| EST_START_DT | DATE | 0 | Estimated Start Date | ||||
| OUTAGE_TYPE_FLG | VARCHAR2 | 4 | Outage Type | ||||
| 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 | ||||
| TMPL_ACT_NUM | NUMBER | 5 | 0 | Template Activity Number | |||
| WORK_PRIORITY_FLG | VARCHAR2 | 4 | Work Priority | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |