| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7INPEC3 | P2E: Policy Closure Action Transactional Data | 4 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
2 | T7INPEC4 | P2E: Policy Closure Action Transactional data | 4 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
3 | T7INPED1 | P2E: Decision transactional table | 9 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
4 | T7INPEI4 | P2E: Policy Step Table | 4 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
5 | T7INPEI4T | P2E: Policy Step Text Table | 5 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
6 | T7INPEL1 | P2E: Request Log table | 10 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
7 | T7INPEL2 | P2E: Policy Log table | 10 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
8 | T7INPEV2 | P2E: Transaction table of validation tab | 4 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
9 | T7INPEW1 | P2E: Workflow Levels and Approvers at Request Level | 4 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
10 | T7INPEW2 | P2E: Follow On Actions for Request Level Workflows | 4 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
11 | T7INPEW9 | P2E: Workflow Log Table for Resubmission and Reminder Mails | 5 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |
12 | T7INPEWA | P2E: Workflow Log Table for Reminder Mails-Initator:HR Admin | 5 | STPID | Policy Step ID | nvarchar | 8 | 0 | | |