EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPAR_AD_INFO_VW(SQL View) |
Index Back |
|---|---|
Additional InformationAdditional Information ARG used by My Simplification Feature |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.CAT_DT_ARG , A.CAT_ID_ARG , A.TERM_NOTIF_ARG , A.TERM_REASON_ARG FROM PS_ADDL_INFO_ARG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ADDL_INFO_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 | CAT_DT_ARG | Date(10) | DATE | Early Registration Code Entry Date for Argentina |
| 5 | CAT_ID_ARG | Character(20) | VARCHAR2(20) NOT NULL | Early Registration Code for Argentina |
| 6 | TERM_NOTIF_ARG | Date(10) | DATE | Termination Notification Date |
| 7 | TERM_REASON_ARG | Character(30) | VARCHAR2(30) NOT NULL | Termination Reason |