| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7UNPF_FI_ADDET | Additional Details | 4 | EFF_START_DATE | Effective Start Date | nvarchar | 8 | 0 | | |
2 | T7UNPF_FI_TRANS | Additional Details | 4 | EFF_START_DATE | Effective Start Date | nvarchar | 8 | 0 | | |
TOPMaintenance Program Definition |
3 | MPDCD | MPD: OBSOLETE - Counter Data for Maintenance Document Items | 19 | EFF_START_DATE | Start Date for Scheduling | nvarchar | 8 | 0 | | |
4 | MPDCYCLE | MPD: Cycle Data for Maintenance Document Items | 20 | EFF_START_DATE | MPD: Effective Start Date for Maintenance Plans | nvarchar | 8 | 0 | | |
TOPOwnership |
5 | GHO_OWN_NET_ASG | Ownership (DOI) assignment to Network Objects | 5 | EFF_START_DATE | Effective From Date | nvarchar | 8 | 0 | | |
TOPTransaction Management |
6 | THXEC_EFF_TMET | Effectiveness Test Method Definition | 6 | EFF_START_DATE | Start Date of the Prospective Effectiveness Test | nvarchar | 2 | 0 | | |