| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CPD/PWS_AGG_MP | Master Project Overall Aggregation Data | 5 | UPDATED_BY | Changed By | nvarchar | 12 | 0 | | |
2 | /GRCPI/GRIACTGRP | Maintain Controller Group and FF ID/Role Assignment | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
3 | /GRCPI/GRIACTRL | Maintain assignment of FF ID or Role to Controllers | 8 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
4 | /GRCPI/GRIAFFOBJ | Maintain SPM Firefighter ID and Role details | 7 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
5 | /GRCPI/GRIAFFOWN | Master table for Fire fighter Owners and FF ID/Roles | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
6 | /GRCPI/GRIAFFUSR | Maintain SPM Firefighter Assignment to FF ID/Roles | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
7 | /GRCPI/GRIARCODE | Master table for Reason Codes | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
8 | BBPD_CMS_DOC_INT | CMS Documents - Internal Versions | 6 | UPDATED_BY | User Name | nvarchar | 12 | 0 | | |
9 | BSCL_CLASS_VIEW | Administration of generated Class Views | 11 | UPDATED_BY | User name | nvarchar | 12 | 0 | | |
10 | GRACANALYZEDOBJ | Analyzed Objects | 8 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
11 | GRACBUSROLEPROV | Table to store busniess role provisioning information | 4 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
12 | GRACBUSROLEUSERS | Business Role User Reassignment | 9 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
13 | GRACCTGRP | Master table for SPM Controller Groups | 4 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
14 | GRACCTGRPDTL | Maintain Controllers assigned to Controller Groups | 5 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
15 | GRACFFCTRL | Maintain assignment of FF ID or Role to Controllers | 8 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
16 | GRACFFCTRLGRP | Maintain Controller Group and FF ID/Role Assignment | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
17 | GRACFFOBJECT | Maintain SPM Firefighter ID and Role details | 7 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
18 | GRACFFOWNER | Master table for Fire fighter Owners and FF ID/Roles | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
19 | GRACFFUSER | Maintain SPM Firefighter Assignment to FF ID/Roles | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
20 | GRACMITOBJECT | Mitigating control assignment | 12 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
21 | GRACMITPROF | Profile mitigating control assignment | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
22 | GRACMITROLE | Role mitigating control assignment | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
23 | GRACMITROLEORG | Role Org mitigating control assignment | 12 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
24 | GRACMITUSER | User mitigating control assignment | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
25 | GRACMITUSERAR | User mitigating control assignment for Access Request | 12 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
26 | GRACMITUSERGP | User Group mitigating control assignment | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
27 | GRACMITUSERORG | User Org mitigating control assignment | 12 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
28 | GRACMITUSERORGAR | User Org mitigating control assignment for Access Request | 13 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
29 | GRACMITUSER_AR | Obsolete | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
30 | GRACMITUSRORG_AR | Obsolete | 12 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
31 | GRACORGRULEHDR | Organization Rule Header | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
32 | GRACOWNER | Master table for Central Owner Administration | 9 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
33 | GRACREASONCOD | Master table for Reason Codes | 6 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
34 | GRACREASONSYS | Reason Code and System assignments | 4 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
35 | GRACREQPROVLOG | Request Provsioning Log | 11 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
36 | GRACSODREPSTATUS | Report status | 5 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
37 | GRACSUPPRULEHDR | Supplement Rule Header | 10 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
38 | GRACSUPRULEHDARC | Supplement Rule Header-Archive | 10 | UPDATED_BY | Field Last Updated by Username | nvarchar | 12 | 0 | | |
TOPPackage Tools |
39 | AKB_JOBSTATE | Obsolete: Job Status | 8 | UPDATED_BY | Last Changed by | nvarchar | 12 | 0 | | |
TOPPortfolio Management |
40 | RPM_CTEMPLATE | Custom Development Template | 9 | UPDATED_BY | User Name | nvarchar | 12 | 0 | | |
TOPTools |
41 | HRPYO_D_CYCL | Cycles | 12 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
42 | HRPYO_D_CYSTP | Steps of the cycles | 25 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
43 | HRPYO_D_DEPCY | Schedule Dependency | 8 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
44 | HRPYO_D_DEPTM | Template Dependency | 7 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
45 | HRPYO_D_SCHDL | Schedule | 13 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
46 | HRPYO_D_SHPROFIL | Schedule profile | 7 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
47 | HRPYO_D_STEPNOTE | Notes for step | 6 | UPDATED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |