HRS_JOBCD_LVW

(SQL View)
 Index Back

Job Code View

Job Code Related Language View - Default search by Job Code/Title Description.

SELECT A.SETID ,A.JOBCODE ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR ,B.DESCRSHORT ,%subrec(JOBCD_FED_SBR,A) FROM %Table(JOBCODE_TBL) A , %Table(JOBCODE_LANG) B WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(JOBCODE_TBL B,A,%CurrentDateIn) AND A.SETID =B.SETID AND A.JOBCODE =B.JOBCODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SET_VLD_HR_02

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

Prompt Table: GVT_PAY_PLAN

8 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series

Prompt Table: GVT_OCCUPATION

9 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program

Prompt Table: TRN_PROGRM_TBL

10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Default Value: INSTALLATION.COMPANY

Prompt Table: COMPANY_TBL

11 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

Default Value: 00

12 GVT_POSN_TITLE_CD Character(4) VARCHAR2(4) NOT NULL Official Posn Title Code

Prompt Table: GVT_PSN_TTL_TBL

13 GVT_OFFICIAL_DESCR Character(70) VARCHAR2(70) NOT NULL Official Position Title
14 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Code

Prompt Table: GVT_ORG_PSN_TTL

15 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title
16 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
BW=Bi-weekly
FB=Fee Basis
PA=Per Annum
PD=Per Diem
PH=Per Hour
PM=Per Month
PW=Piece Work
SM=Semi-monthly
SY=School Year
WC=Without Compensation

Default Value: INSTALLATION.GVT_PAY_BASIS

17 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

Prompt Table: GVT_SUBAGCY_TBL

18 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID

Prompt Table: GVT_POI_VW

19 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title
D=(Data Transcribing)
O=(Office Automation)
S=(Stenography)
T=(Typing)
20 GVT_OPM_CERT_NBR Character(8) VARCHAR2(8) NOT NULL OPM Certification Nbr
21 GVT_POSN_CLASS_STD Character(254) VARCHAR2(254) NOT NULL Position Classification Stds
22 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

Default Value: 1

23 GVT_IA_ACTIONS Character(1) VARCHAR2(1) NOT NULL IA Actions

Y/N Table Edit

Default Value: N

24 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure

Y/N Table Edit

Default Value: N

25 GVT_EMP_FIN_INT Character(1) VARCHAR2(1) NOT NULL Employee Financial Interests

Y/N Table Edit

Default Value: N

26 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
27 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard

Prompt Table: GVT_CLS_STD_TBL

28 GVT_CLASSIFIER_ID Character(11) VARCHAR2(11) NOT NULL Classifier's ID
29 GVT_DT_CLASSIFIED Date(10) DATE Date Classified

Default Value: %date

30 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2

Prompt Table: GVT_BARG_UNIT

31 GVT_FUND_SOURCE Character(1) VARCHAR2(1) NOT NULL Fund Source
A=Appropriated Funds
E=External Funds
N=Non-Appropriated Funds
O=Other Funds
32 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
33 GVT_PERF_PLAN Character(8) VARCHAR2(8) NOT NULL Performance Plan

Prompt Table: GVT_PERF_PLAN

34 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
35 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
36 GVT_NFC_FUNCTN_CD Character(2) VARCHAR2(2) NOT NULL Federal NFC field
A=Add
C=Change
D=Delete/Restore
I=Inactivate
R=Reactivate

Default Value: A

37 GVT_OFF_TITLEPREFX Character(2) VARCHAR2(2) NOT NULL Federal NFC field
A=Apprentice
B=Data Transcription
C=Office Automation
D=Day
E=Steno/Office Automation
F=Foreman
G=General Foreman
H=Helper
I=Inspection
J=Coor
K=Supervisor
M=Instructor
N=Trainee
O=Senior
R=Leader
T=Typing
V=Stay in School
W=Night
X=Trainee Leader
Y=Stenography
38 GVT_NFC_PI_IND_OVR Character(1) VARCHAR2(1) NOT NULL Federal NFC Field

Y/N Table Edit

Default Value: N

39 GVT_PPM_JOB_IDENTY Character(1) VARCHAR2(1) NOT NULL Program and Project Management
1=Program Manager
2=Project Manager
3=Program and Project Manager
4=Not Applicable
40 GVT_RW_TW_TYPE Character(2) VARCHAR2(2) NOT NULL Remote/Telework Type
MW=Mobile Work Agreement
NN=Non-teleworker
RW=Remote Work Agreement
TF=Frequent Routine Telework
TP=Periodic Routine Telework
TS=Situational Telework Agreement