GVT_PI_POIP_VW(SQL View) |
Index Back |
---|---|
Gvt PI Position Detail View |
SELECT DISTINCT PD.POSITION_NBR ,99 ,PD.EFFDT ,0 ,JC.COMPANY ,JC.GVT_SUB_AGENCY ,JC.GVT_POI ,JC.JOBCODE ,JC.GRADE ,JC.GVT_PAY_PLAN ,JC.GVT_OCC_SERIES ,JC.GVT_FUNC_CLASS ,JC.GVT_PAREN_TITLE ,JC.MANAGER_LEVEL ,JC.GVT_POSN_TITLE_CD ,JC.GVT_OFFICIAL_DESCR ,PD.GVT_POSN_LOC ,JC.GVT_DT_CLASSIFIED ,JC.GVT_PATCOB_CD ,JC.EFF_STATUS ,JC.EFFDT ,JC.GVT_CLASSIFIER_ID ,PD.ACTION_REASON ,PD.POSITION_NBR ,PD.FLSA_STATUS ,JC.GVT_EMP_FIN_INT ,JC.GVT_EXEC_FIN_DISCL ,PD.GVT_POSN_OCCUPIED ,PD.GVT_POSN_SENS_CD ,PD.GVT_PROC_INTEG_PSN ,PD.GVT_LEO_POSITION ,PD.SAL_ADMIN_PLAN ,PD.GVT_COMP_AREA ,PD.GVT_COMP_LEVEL ,PD.GVT_ORG_TTL_CD ,PD.GVT_ORG_TTL_DESCR ,PD.DEPTID ,PD.GVT_TARGET_GRADE ,PD.LOCATION ,PD.GVT_LAST_AUDIT_DT ,PD.BARG_UNIT ,PD.BUDGETED_POSN ,PD.LANGUAGE_SKILL ,PD.GVT_NTE_DATE ,PD.GVT_PRESIDENT_APPT ,PD.EFF_STATUS ,PD.GVT_DT_POSN_ESTAB ,PD.GVT_DRUG_TEST_REQ ,PD.GVT_PI_UPD_IND ,PD.GVT_WORK_SCHED ,LOC.GVT_GEOLOC_CD FROM PS_POSITION_DATA PD ,PS_JOBCODE_TBL JC ,PS_LOCATION_TBL LOC WHERE PD.JOBCODE=JC.JOBCODE AND JC.SETID=LOC.SETID AND JC.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL WHERE JOBCODE = JC.JOBCODE AND EFFDT<=PD.EFFDT) AND PD.LOCATION = LOC.LOCATION AND LOC.EFFDT = ( SELECT MAX( EFFDT) FROM PS_LOCATION_TBL LOC2 WHERE PD.LOCATION = LOC2.LOCATION) |
# | 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 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
6 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL | Sub-Agency |
7 | GVT_POI | Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
9 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
10 | GVT_PAY_PLAN | Character(2) | VARCHAR2(2) NOT NULL | Pay Plan |
11 | GVT_OCC_SERIES | Character(4) | VARCHAR2(4) NOT NULL | Occupational Series |
12 | GVT_FUNC_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Functional Class
00=Not Applicable 11=Research 12=Research,Contract/Grant Admin 13=Development 14=Test and Evaluation 21=Design 22=Construction 23=Production 24=Install/Operations/Maintenance 31=Data Collect/Process/Analysis 32=Scientific/Technical Info 41=Standards and Specifications 42=Regulatory Enforcement/License 51=Natural Resource Operations 81=Clinical Practice/Counseling 91=Planning 92=Management 93=Teaching/Training 94=Technical Assistance/Consult 99=Other |
13 | GVT_PAREN_TITLE | Character(1) | VARCHAR2(1) NOT NULL |
Parenthetical Title
D=(Data Transcribing) O=(Office Automation) S=(Stenography) T=(Typing) |
14 | MANAGER_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Manager Level
0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager |
15 | GVT_POSN_TITLE_CD | Character(4) | VARCHAR2(4) NOT NULL | Official Posn Title Code |
16 | GVT_OFFICIAL_DESCR | Character(70) | VARCHAR2(70) NOT NULL | Official Position Title |
17 | GVT_POSN_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Position Location
F=Field H=Headquarters |
18 | GVT_DT_CLASSIFIED | Date(10) | DATE | Date Classified |
19 | GVT_PATCOB_CD | Character(1) | VARCHAR2(1) NOT NULL |
PATCOB Code
1=Exception 1 2=Exception 2 3=Exception 3 4=Exception 4 5=Exception 5 6=Exception 6 7=Exception 7 8=Exception 8 A=Administrative B=Blue Collar C=Clerical M=Mixed Collar O=Other White Collar P=Professional T=Technical |
20 | GVT_EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
GVT Effective Status
A=Active I=Inactive |
21 | GVT_STATUS_DT | Date(10) | DATE | Effective Status Date |
22 | GVT_CLASSIFIER_ID | Character(11) | VARCHAR2(11) NOT NULL | Classifier's ID |
23 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
24 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
25 | FLSA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative C=Computer Employee E=Executive H=Highly Compensated Employees M=Management N=Nonexempt O=Outside Salesperson P=Professional V=Nonexempt Alt Overtime X=No FLSA Required |
26 | GVT_EMP_FIN_INT | Character(1) | VARCHAR2(1) NOT NULL | Employee Financial Interests |
27 | GVT_EXEC_FIN_DISCL | Character(1) | VARCHAR2(1) NOT NULL | Executive Financial Disclosure |
28 | GVT_POSN_OCCUPIED | Character(1) | VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive 2=Excepted 3=SES General 4=SES Career Reserved |
29 | GVT_POSN_SENS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Sensitivity Code
1=Non Sensitive 2=Non-Critical, Sensitive 3=Critical Sensitive 4=Special Sensitive |
30 | GVT_PROC_INTEG_PSN | Character(1) | VARCHAR2(1) NOT NULL | Procurement Integ Posn |
31 | GVT_LEO_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
LEO/Fire Position
5=5USC 5305 LEO C=D.C. Police Forces F=Fire Fighter N=Not Applicable P=Primary FEPCA S=Secondary FEPCA |
32 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
33 | GVT_COMP_AREA | Character(2) | VARCHAR2(2) NOT NULL | Competitive Area |
34 | GVT_COMP_LEVEL | Character(4) | VARCHAR2(4) NOT NULL | Competitive Level |
35 | GVT_ORG_TTL_CD | Character(4) | VARCHAR2(4) NOT NULL | Organization Posn Title Code |
36 | GVT_ORG_TTL_DESCR | Character(70) | VARCHAR2(70) NOT NULL | Organization Position Title |
37 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
38 | GVT_TARGET_GRADE | Character(2) | VARCHAR2(2) NOT NULL | Target Grade |
39 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
40 | GVT_LAST_AUDIT_DT | Date(10) | DATE | Position Audit Date |
41 | BARG_UNIT | Character(4) | VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1 2=Bargaining Unit 2 |
42 | BUDGETED_POSN | Character(1) | VARCHAR2(1) NOT NULL | Budgeted Position |
43 | LANGUAGE_SKILL | Character(2) | VARCHAR2(2) NOT NULL | Language Required |
44 | GVT_NTE_DATE | Date(10) | DATE | Not To Exceed Date |
45 | GVT_PRESIDENT_APPT | Character(1) | VARCHAR2(1) NOT NULL | Presidential Appt Posn |
46 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
47 | GVT_DT_POSN_ESTAB | Date(10) | DATE | Date Position Established |
48 | GVT_DRUG_TEST_REQ | Character(1) | VARCHAR2(1) NOT NULL | Drug Test (Applicable) |
49 | GVT_PI_UPD_IND | Character(1) | VARCHAR2(1) NOT NULL |
PI upd ind
A=Applied at NFC I=Auto Action Inserted N=Not Ready to Process P=In Process R=Ready To Process S=SINQ Error Z=Other |
50 | GVT_WORK_SCHED | Character(1) | VARCHAR2(1) NOT NULL |
Work Schedule
B=Baylor Plan F=Full Time G=Full Time Seasonal I=Intermittent J=Intermittent-Seasonal P=Part Time Q=Part-Time Seasonal R=Part-Time Phased Retiree S=Part-Time Job Sharer T=Part-Time Seasonal Job Sharer |
51 | GVT_GEOLOC_CD | Character(9) | VARCHAR2(9) NOT NULL | Geographic Location Code |