Module: Work Asset Analytics
Type: Dimension
PERMIT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PERMIT_ID | VARCHAR2 | 12 | True | Permit | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 38 | Status | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| EFF_DT | DATE | 0 | Effective Date | ||||
| EXPIRATION_DT | DATE | 0 | Expiration Date | ||||
| FEE_AMOUNT | NUMBER | 17 | 3 | Fee Amount | |||
| FEE_AMOUNT_PAID | NUMBER | 18 | 3 | Fee Amount Paid | |||
| FEE_REQUIRED_BY_DT | DATE | 0 | Fee Required By Date | ||||
| FEE_REQUIRED_FLG | VARCHAR2 | 38 | Fee Required | ||||
| PERMIT_NUM | VARCHAR2 | 38 | Permit Number | ||||
| PERMIT_TMPL_CD | VARCHAR2 | 30 | Permit Template | ||||
| WORK_WIN_END_TM | TIMESTAMP | 0 | 6 | Work Window End Time | |||
| WORK_WIN_START_TM | TIMESTAMP | 0 | 6 | Work Window Start Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |