EMPLIDEMPL_RCDEFFDTEFFSEQCAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
A=Applied at NFC
I=Auto Action Inserted
N=Not Ready to Process
P=In Process
R=Ready To Process
S=SINQ Error
Z=Other
GVT_PI_RMKS_VW(SQL View) |
Index Back |
|---|---|
Payroll Interface par remarks |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,B.COMPANY ,B.GVT_SUB_AGENCY ,B.GVT_POI ,NID.NATIONAL_ID ,B.GVT_STATUS_TYPE ,B.GVT_NOA_CODE ,A.GVT_SF50_REMARK ,A.GVT_REMARK_LINE1 ,A.GVT_REMARK_LINE2 ,A.GVT_REMARK_LINE3 ,A.GVT_REMARK_LINE4 ,A.GVT_REMARK_LINE5 ,A.GVT_REMARK_LINE6 ,A.GVT_REMARK_LINE7 ,A.GVT_REMARK_LINE8 ,A.GVT_REMARK_LINE9 ,B.GVT_PI_UPD_IND FROM PS_GVT_PAR_REMARKS A ,PS_GVT_JOB B ,PS_GVT_PERS_NID NID WHERE B.EMPLID=A.EMPLID AND B.EMPL_RCD=A.EMPL_RCD AND B.EFFDT = A.EFFDT AND B.EFFSEQ = A.EFFSEQ AND NID.EMPLID=A.EMPLID AND NID.EMPL_RCD=A.EMPL_RCD AND NID.EFFDT = A.EFFDT AND NID.EFFSEQ = A.EFFSEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL | Sub-Agency |
| 7 | GVT_POI | Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
| 8 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 9 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |
| 10 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
| 11 | GVT_SF50_REMARK | Character(3) | VARCHAR2(3) NOT NULL | SF50 Remark Code |
| 12 | GVT_REMARK_LINE1 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 1 |
| 13 | GVT_REMARK_LINE2 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 2 |
| 14 | GVT_REMARK_LINE3 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 3 |
| 15 | GVT_REMARK_LINE4 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 4 |
| 16 | GVT_REMARK_LINE5 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 5 |
| 17 | GVT_REMARK_LINE6 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 6 |
| 18 | GVT_REMARK_LINE7 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 7 |
| 19 | GVT_REMARK_LINE8 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 8 |
| 20 | GVT_REMARK_LINE9 | Character(72) | VARCHAR2(72) NOT NULL | Remark Line 9 |
| 21 | GVT_PI_UPD_IND | Character(1) | VARCHAR2(1) NOT NULL |
PI upd ind
A=Applied at NFC I=Auto Action Inserted N=Not Ready to Process P=In Process R=Ready To Process S=SINQ Error Z=Other |