GVT_JOB_PRT_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT JOB.EMPLID , JOB.EMPL_RCD , JOB.EFFDT , JOB.EFFSEQ , PER.NAME , %Substring(PERNID.NATIONAL_ID,1,9) , JOB.GVT_NOA_CODE , JOB.BUSINESS_UNIT , JOB.DEPTID , JOB.LOCATION , JOB.GVT_WIP_STATUS , 'USFED' FROM PS_GVT_JOB JOB , PS_GVT_NM_DT_VW PER , PS_GVT_PERS_NID PERNID , PS_SCRTY_TBL_DEPT SEC WHERE JOB.EMPLID = PER.EMPLID AND JOB.EMPL_RCD = PER.EMPL_RCD AND JOB.EFFDT = PER.EFFDT AND JOB.EFFSEQ = PER.EFFSEQ AND PERNID.EMPLID = PER.EMPLID AND PERNID.EMPL_RCD = PER.EMPL_RCD AND PERNID.EFFDT = PER.EFFDT AND PERNID.EFFSEQ = PER.EFFSEQ %Sql(SCRTY_DEPT_TREE_WHERE,SEC,JOB) |
| # | 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 Rcd Nbr |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 7 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 11 | GVT_PAR_CUR_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Current PAR Status |
| 12 | GVT_WIP_RECORD | Character(25) | VARCHAR2(25) NOT NULL | Transaction |