RS_ORGEMPLBR_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , B.SETID , A.DEPTID , A.EMPL_STATUS FROM %Table(JOB) A , %Table(SET_CNTRL_REC) B , %Table(INSTALLATION_RS) D , %Table(RS_WORKER_TBL) E , %Table(RS_ELGBL_WRKR) ELG WHERE A.EMPLID = ELG.EMPLID AND ELG.SYSTEM_SOURCE = 'RS' AND A.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.RECNAME = D.ORG_RECNAME AND E.EMPLID = A.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSONAL_DATA |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPTID_NB_VW |
| 7 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employee Status
A=Active D=Deceased I=Inactive L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration Default Value: A |