| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IAM/C_ACTTYPE | Activity Type | 10 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
2 | /IAM/C_ISSUETYP | Issue Type | 17 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
3 | /IAM/C_STPRF | Status Profile | 3 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
4 | /IAM/C_STPRFA | Status Profile Actions | 3 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
5 | /IAM/C_STPRFAC | Status Profile Action Condition | 3 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
6 | /IAM/C_STPRFD | Default Status for Status Profile | 3 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
7 | /IAM/C_STPRFD_T | Status Field Description in Profile | 4 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
8 | /IAM/C_STPRF_T | Status Profile Description | 4 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
9 | /IAM/D_ACT_ROOT | Root | 23 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
10 | /IAM/D_I_ROOT | Root node DB table | 22 | STATUS_PROFILE | Status Profile | nvarchar | 3 | 0 | | |
11 | /XLSO/WEC_PSPPTP | Payment Service Provider Payment Transaction Status Profile | 1 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
12 | /XLSO/WEC_PSPPTS | Payment Service Provider Payment Transaction Status | 1 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
13 | /XLSO/WEC_PSP_PT | Payment Service Provider Payment Transaction Status Profile | 2 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
14 | /XLSO/WEC_PSP_ST | Payment Service Provider Payment Transaction Status | 2 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
15 | GHO_SAM_PROFILE | Profiles for Production Network | 4 | STATUS_PROFILE | GHO User Status Profile | nvarchar | 8 | 0 | | |
16 | GHO_SAM_RSP | Record Status Process | 3 | STATUS_PROFILE | GHO User Status Profile | nvarchar | 8 | 0 | | |
17 | GHO_STATUS_PROF | Permitted object types for status profile | 3 | STATUS_PROFILE | GHO User Status Profile | nvarchar | 8 | 0 | | |
TOPBasic Functions |
18 | SLS_C_PAYSP_PTS | Payment Service Provider Payment Transaction Status | 1 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
TOPCapacity and Resource Planning |
19 | /MRSS/C_RM_CAND | Candidate Status Profiles | 3 | STATUS_PROFILE | Status Profile | nvarchar | 8 | 0 | | |
20 | /MRSS/C_RM_QK_C | Customizing table for Quick Close / Book | 2 | STATUS_PROFILE | Status Profile | nvarchar | 8 | 0 | | |
TOPChargeback |
21 | TWCBCONTRTYPE | Condition Contract Type | 13 | STATUS_PROFILE | Status Schema for Condition Contract | nvarchar | 8 | 0 | | |
TOPCustomer Bill of Services |
22 | /SAPBOQ/SESTYP | Service Entry Sheet Type | 11 | STATUS_PROFILE | Status Profile | nvarchar | 8 | 0 | | |
TOPEngineering Documents |
23 | EDMS_CT01 | EDMS: Document Types | 3 | STATUS_PROFILE | Status Profile ID | nvarchar | 32 | 0 | | |
TOPMaster Data |
24 | GMFGC_LIFE | Field group criteria (Grants) | 3 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
25 | GMFGC_USER | Field group criteria (Grants) system+user status | 3 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
26 | GMGRTYPE | Grant type | 6 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
27 | GMSTATNET | Grants Management Status Network | 3 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
28 | GMSTATNETHISTORY | Historical status information Sponsored Programs Mgmt | 4 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
29 | GMSTATNET_INT | Grants Management Status Network | 3 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
30 | GMWFGRANTM | GM Workflow Grant Master | 5 | STATUS_PROFILE | Status profile for the user states attached to system states | nvarchar | 8 | 0 | | |
TOPNetwork Objects |
31 | GHO_IFLOT_EXT | Function location extension table | 111 | STATUS_PROFILE | Status Management Profile ID | nvarchar | 3 | 0 | | |
TOPProject System |
32 | PSHLP_CACHE_DB | Maintains Project Cache Information | 17 | STATUS_PROFILE | | ntext | 1073741823 | 0 | | |
33 | PSHLP_CACHE_DB_N | Maintains Project Cache Information | 17 | STATUS_PROFILE | | image | 2147483647 | 0 | | |
TOPWeb Channel Basic Functions - Payment Method |
34 | COMC_WEC_PSP_PTP | Payment Service Provider Payment Transaction Status Profile | 1 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
35 | COMC_WEC_PSP_PTS | Payment Service Provider Payment Transaction Status | 1 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
36 | COMC_WEC_PSP_P_T | Payment Service Provider Payment Transaction Status Profile | 2 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |
37 | COMC_WEC_PSP_S_T | Payment Service Provider Payment Transaction Status | 2 | STATUS_PROFILE | Payment Status Profile | nvarchar | 4 | 0 | | |