GP_PSLP_NET_TMP(SQL Table) |
Index Back |
---|---|
Payslip Net Temporary TableThis temporary table stores the Net for the payslip |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | PMT_GRP_ID | Number(3,0) | SMALLINT NOT NULL | Group Id for grouping payment |
4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
5 | GP_PSLP_NET_PAY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field is the sum of all payments in a payslip |
6 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
7 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
9 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
11 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
12 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
13 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
14 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
15 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
16 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
17 | PYMT_DT | Date(10) | DATE | Payment Date |
18 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
19 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
20 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
21 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
22 | GP_PSLP_ID | Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |
23 | PAYMENT_MTHD1 | Character(1) | VARCHAR2(1) NOT NULL |
Zero Net payment method
N=Negative Net Z=Zero Net |
24 | GP_PSLP_GEN_DT | Date(10) | DATE | Date Payslip was Generated |