GVT_JOB_PRT_VW2(SQL View) |
Index Back |
|---|---|
Job PAR Print with Actn Dt07/21/03 Lee - ICE508075000 - Add substring to viewtext for SQL validator. |
| 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 , TRK.GVT_DATE_WRK , TRK.GVT_WIP_STATUS , 'USFED' FROM PS_GVT_EE_DATA_TRK TRK , PS_GVT_JOB JOB , PS_GVT_NM_DT_VW PER , PS_GVT_PERS_NID PERNID , PS_SCRTY_TBL_DEPT SEC WHERE TRK.EMPLID = JOB.EMPLID AND TRK.EMPL_RCD = JOB.EMPL_RCD AND TRK.EFFDT = JOB.EFFDT AND TRK.EFFSEQ = JOB.EFFSEQ AND PER.EMPLID = JOB.EMPLID AND PER.EMPL_RCD = JOB.EMPL_RCD AND PER.EFFDT = JOB.EFFDT AND PER.EFFSEQ = JOB.EFFSEQ AND PERNID.EMPLID = JOB.EMPLID AND PERNID.EMPL_RCD = JOB.EMPL_RCD AND PERNID.EFFDT = JOB.EFFDT AND PERNID.EFFSEQ = JOB.EFFSEQ AND PERNID.COUNTRY = 'USA' AND PERNID.NATIONAL_ID_TYPE = 'PR' %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 Record |
| 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_DATE_WRK | Date(10) | DATE | Action Taken |
| 13 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Work-in-Progress Status |
| 14 | GVT_WIP_RECORD | Character(25) | VARCHAR2(25) NOT NULL | WIP record transaction. |