EMPLIDEMPL_RCDEFFDTEFFSEQMIL_JOB_CURR_VW(SQL View) |
Index Back |
|---|---|
Current Military Data on JOBMilitary Data on the JOB record |
| SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ ,M.MIL_RANK , M.MIL_RANK_ENTRY_DT , M.MIL_WORN_RANK , M.MIL_WORN_RNK_TYPE , J.SAL_ADMIN_PLAN , J.GRADE , M.JOB_FAMILY , M.JOB_FUNCTION , M.JOB_SUB_FUNC FROM PS_JOB_MIL M , PS_JOB J WHERE M.EFFSEQ = ( SELECT MAX(M1.EFFSEQ) FROM PS_JOB_MIL M1 WHERE M.EMPLID = M1.EMPLID AND M.EMPL_RCD = M1.EMPL_RCD AND M.EFFDT = M1.EFFDT) AND (M.EmplID = J.EmplID AND M.EMPL_RCD = J.EMPL_RCD AND M.EffDt = J.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 | MIL_RANK | Character(5) | VARCHAR2(5) NOT NULL | Military Rank |
| 6 | MIL_RANK_ENTRY_DT | Date(10) | DATE | The employee's date when the new rank was given |
| 7 | MIL_WORN_RANK | Character(5) | VARCHAR2(5) NOT NULL | Worn Rank |
| 8 | MIL_WORN_RNK_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Worn Rank Type |
| 9 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 10 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 11 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 12 | JOB_FUNCTION | Character(3) | VARCHAR2(3) NOT NULL | Job Function Code |
| 13 | JOB_SUB_FUNC | Character(3) | VARCHAR2(3) NOT NULL | Job sub Function |