GP_EPM_GUI_TMP(SQL Table) |
Index Back |
---|---|
EPM Guide TableTemporary tables used by EPM. This table is populated by Report Data. Header for payroll results by segment. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | |
4 | Number(3,0) | SMALLINT NOT NULL | Empl Record | |
5 | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group | |
6 | Character(18) | VARCHAR2(18) NOT NULL | calendar id | |
7 | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID | |
8 | Number(4,0) | SMALLINT NOT NULL | Result Segment Number | |
9 | Character(22) | VARCHAR2(22) NOT NULL | Output Result Key | |
10 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
12 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
13 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
15 | PYMT_DT | Date(10) | DATE | Payment Date |
16 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
17 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
18 | SEG_BGN_DT | Date(10) | DATE | Payee Process Segment's Begin Date |
19 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
20 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
21 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
22 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
23 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
24 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
25 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
26 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
27 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
28 | EMPL_CTG | Character(6) | VARCHAR2(6) NOT NULL | Employee Category |