EMPLIDPrompt Table: PERSON
EMPL_RCDDefault Value: 0
EFFDTDefault Value: %date
EFFSEQGPMY_ORG_ASN_VW(SQL View) |
Index Back |
|---|---|
Per Org/Inst/Current JobView of PER_ORG_ASGN joined to PER_ORG_INST, and the current row in JOB and JOB_DATES The HIRE, LAST_HIRE_DT come from the Controlling instance for the EMPL_RCD |
| SELECT J.EMPLID ,J.EMPL_RCD , J.EFFDT , J.EFFSEQ ,J.TERMINATION_DT ,J.EXPECTED_RETURN_DT FROM PS_JOB J WHERE J.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB JOB2 WHERE J.EMPLID = JOB2.EMPLID AND J.EMPL_RCD = JOB2.EMPL_RCD AND J.EFFSEQ= JOB2.EFFSEQ) AND J.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB JOB3 WHERE JOB3.EMPLID = J.EMPLID AND JOB3.EMPL_RCD = J.EMPL_RCD AND JOB3.EFFDT = J.EFFDT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: 0 |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 6 | EXPECTED_RETURN_DT | Date(10) | DATE | Expected Return Date |