CAL_RUN_IDPrompt Table: GP_CAL_RUN
GP_PSLP_IDGP_PSLP_GDE_VW(SQL View) |
Index Back |
|---|---|
Payslip Guide TableThis record is the guide table for Global Payroll Payslips. |
| SELECT A.CAL_RUN_ID ,A.GP_PSLP_ID ,A.EMPLID ,B.NAME ,A.GP_PSLP_TMPL ,D.DESCR FROM PS_GP_PSLP_GDE A , PS_NAMES B , PS_GP_PSLP_TMPL D WHERE B.EMPLID=A.EMPLID AND B.NAME_TYPE = 'PRI' AND D.GP_CNTRY_PSLP_TMPL = A.GP_CNTRY_PSLP_TMPL AND A.GP_PSLP_TMPL = D.GP_PSLP_TMPL AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_NAMES C WHERE C.EMPLID = A.EMPLID AND C.NAME_TYPE = B.NAME_TYPE AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN |
| 2 | GP_PSLP_ID |
Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | GP_PSLP_TMPL | Character(12) | VARCHAR2(12) NOT NULL | This field is used to uniquely identify a payslip template. |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |