GVT_JOB_ASOF_VW(SQL View) |
Index Back |
|---|---|
GVT_JOB_ASOF_VWThis view conains the latest GVT_JOB rows as of the date in PSASOFDATE. |
| select a.emplid, a.EMPL_RCD, a.effdt, a.effseq, a.gvt_trans_nbr, a.gvt_trans_nbr_seq, b.asofdate FROM PS_GVT_JOB A, PSASOFDATE b WHERE A.EFFDT = (SELECT MAX(EFFDT) FROM PS_GVT_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT <= b.asofdate) AND A.EFFSEQ = (SELECT MAX(EFFSEQ) FROM PS_GVT_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT) |
| # | 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 | Effective Date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | GVT_TRANS_NBR | Number(1,0) | SMALLINT NOT NULL | Transaction Nbr |
| 6 | GVT_TRANS_NBR_SEQ | Number(1,0) | SMALLINT NOT NULL | Transaction Nbr / Seq |
| 7 | ASOFDATE | Date(10) | DATE | As of Date |