EMPLIDEMPL_RCDEFFDTDefault Value: %date
C=Corporate Retirement Plan
G=Government Retirement Plan
U=Undefined
GPAR_AD_SIJP_VW(SQL View) |
Index Back |
|---|---|
Additional SIJPAdditional SIJP Information used by My Simplification Feature |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.RETPLAN_ARG , A.AFJP_CD_ARG , A.HIREMOD_CD_ARG , A.EMPSIT_CD_ARG , A.CONDITION_CD_ARG , A.ACCIDENT_CD_ARG , A.GEOZONE_CD_ARG , A.ACTIVITY_CD_ARG FROM PS_ADDL_SIJP_ARG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ADDL_SIJP_ARG B , PS_JOB C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND B.EFFDT <= C.EFFDT AND B.EFF_STATUS = 'A') |
| # | 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 Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | RETPLAN_ARG | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Plan
C=Corporate Retirement Plan G=Government Retirement Plan U=Undefined |
| 5 | AFJP_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL | AFJP Code Field |
| 6 | HIREMOD_CD_ARG | Character(3) | VARCHAR2(3) NOT NULL | Hire Modality Code |
| 7 | EMPSIT_CD_ARG | Character(2) | VARCHAR2(2) NOT NULL | Country Extension Argentine - Employee Situation Code Field |
| 8 | CONDITION_CD_ARG | Character(2) | VARCHAR2(2) NOT NULL | Condition Code Field |
| 9 | ACCIDENT_CD_ARG | Character(2) | VARCHAR2(2) NOT NULL | Accident Code Field |
| 10 | GEOZONE_CD_ARG | Character(2) | VARCHAR2(2) NOT NULL | Geographical Zone Code |
| 11 | ACTIVITY_CD_ARG | Character(3) | VARCHAR2(3) NOT NULL | Activity Type Code Field |