GVT_JOBCD_TBL_V

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	JOB_FUNCTION	Character(3)	VARCHAR2(3) NOT NULL	Job Function Code Prompt Table: JOBFUNCTION_TBL
8	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID Prompt Table: %SAL_SETID_PRMP
9	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Prompt Table: %SAL_PLN_PRMPT2
10	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: %SAL_GRD_PRMPT2
11	STEP	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: %SAL_STP_PRMPT2
12	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 Default Value: 8
13	SURVEY_SALARY	Number(8,0)	INTEGER NOT NULL	Survey Salary
14	SURVEY_JOB_CODE	Character(8)	VARCHAR2(8) NOT NULL	Salary Survey Job Code
15	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code Prompt Table: UNION_TBL
16	RETRO_RATE	Signed Number(8,4)	DECIMAL(6,4) NOT NULL	Retroactive Rate
17	RETRO_PERCENT	Signed Number(8,4)	DECIMAL(6,4) NOT NULL	Retroactive Percent
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
19	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours Default Value: OPR_DEF_TBL_HR.STD_HRS_DEFAULT
20	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Default Value: OPR_DEF_TBL_HR.STD_HRS_FREQUENCY Prompt Table: STDHRS_FREQ_VW
21	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Default Value: INSTALLATION.COMP_FREQUENCY Prompt Table: COMP_FREQ_VW
22	WORKERS_COMP_CD	Character(4)	VARCHAR2(4) NOT NULL	Workers' Comp Code
23	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family Prompt Table: JOB_FAMILY_TBL
24	JOB_KNOWHOW_POINTS	Number(5,0)	INTEGER NOT NULL	Knowhow-Points
25	JOB_ACCNTAB_POINTS	Number(5,0)	INTEGER NOT NULL	Accountability-Points
26	JOB_PROBSLV_POINTS	Number(5,0)	INTEGER NOT NULL	Problem-Solving-Points
27	JOB_POINTS_TOTAL	Number(5,0)	INTEGER NOT NULL	Total Points
28	JOB_KNOWHOW_PCT	Number(5,1)	DECIMAL(4,1) NOT NULL	Knowhow-Percent
29	JOB_ACCNTAB_PCT	Number(5,1)	DECIMAL(4,1) NOT NULL	Accountability-Percent
30	JOB_PROBSLV_PCT	Number(5,1)	DECIMAL(4,1) NOT NULL	Problem-Solving-Percent
31	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
32	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped Default Value: N
33	MED_CHKUP_REQ	Character(1)	VARCHAR2(1) NOT NULL	Medical Checkup Required Y/N Table Edit Default Value: N
34	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 Default Value: N
35	EEO1CODE	Character(1)	VARCHAR2(1) NOT NULL	EEO-1 Job Category 1=Officials and Managers 2=Professionals 3=Technicians 4=Sales Workers 5=Administrative Support Workers 6=Craft Workers 7=Operatives 8=Laborers and Helpers 9=Service Workers A=Executive/Sr Level Officials B=First/Mid Level Officials N=No EEO-1 Reporting Default Value: N
36	EEO4CODE	Character(1)	VARCHAR2(1) NOT NULL	EEO-4 Job Category 1=Officials and Administrators 2=Professionals 3=Technicians 4=Protective Service 5=Paraprofessionals 6=Administrative Support 7=Skilled Craft 8=Service Maintenance N=No EEO-4 Reporting Default Value: N
37	EEO5CODE	Character(2)	VARCHAR2(2) NOT NULL	EEO-5 Job Category 1=Officials,Administrators,Mgrs 10=Librarian/Audiovisual 11=Consultants/Supv.of Instructn 12=Other Professional Staff 13=Teacher Aides 14=Technicians 15=Clerical/Secretarial 16=Service Workers 17=Craft Workers (Skilled) 18=Laborers (Unskilled) 2=Principals 3=Asst. Principals-Teaching 4=Asst. Principals-Nonteaching 5=Elementary Classroom Teachers 6=Secondary Classroom Teachers 7=Other Classroom Teachers 8=Guidance 9=Psychological N=No EEO-5 Reporting Default Value: N
38	EEO6CODE	Character(1)	VARCHAR2(1) NOT NULL	EEO-6 Job Category 1=Executive/Admin/Managerial 2=Faculty 3=Professional Nonfaculty 4=Secretarial/Clerical 5=Technical/Paraprofessional 6=Skilled Crafts 7=Service Maintenance Workers N=No EEO-6 Reporting Default Value: N
39	EEO_JOB_GROUP	Character(4)	VARCHAR2(4) NOT NULL	EEO Job Group Prompt Table: EEO_JOB_GRP_TBL
40	US_SOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Occupational Classif Prompt Table: US_SOC_TBL
41	IPEDSSCODE	Character(1)	VARCHAR2(1) NOT NULL	IPEDS-S Job Category Default Value: N
42	US_OCC_CD	Character(4)	VARCHAR2(4) NOT NULL	Occupational Classification Code Prompt Table: US_OCC_TBL
43	AVAIL_TELEWORK	Character(1)	VARCHAR2(1) NOT NULL	Job Code Available for Telework Y/N Table Edit Default Value: N
44	BN_ACA_ELIG_IND	Character(1)	VARCHAR2(1) NOT NULL	ACA (Affordable Care Act) Eligibility Indicator A=Always Eligible E=Eligible I=Ineligible U=To be determined X=Excluded
45	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan Prompt Table: GVT_PAY_PLAN
46	GVT_OCC_SERIES	Character(4)	VARCHAR2(4) NOT NULL	Occupational Series Prompt Table: GVT_OCCUPATION
47	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program Prompt Table: TRN_PROGRM_TBL
48	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: INSTALLATION.COMPANY Prompt Table: COMPANY_TBL
49	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
50	GVT_POSN_TITLE_CD	Character(4)	VARCHAR2(4) NOT NULL	Official Posn Title Code Prompt Table: GVT_PSN_TTL_TBL
51	GVT_OFFICIAL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Official Position Title
52	GVT_ORG_TTL_CD	Character(4)	VARCHAR2(4) NOT NULL	Organization Posn Title Code Prompt Table: GVT_ORG_PSN_TTL
53	GVT_ORG_TTL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Organization Position Title
54	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
55	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency Prompt Table: GVT_SUBAGCY_TBL
56	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID Prompt Table: GVT_POI_VW
57	GVT_PAREN_TITLE	Character(1)	VARCHAR2(1) NOT NULL	Parenthetical Title D=(Data Transcribing) O=(Office Automation) S=(Stenography) T=(Typing)
58	GVT_OPM_CERT_NBR	Character(8)	VARCHAR2(8) NOT NULL	OPM Certification Nbr
59	GVT_POSN_CLASS_STD	Character(254)	VARCHAR2(254) NOT NULL	Position Classification Stds
60	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
61	GVT_IA_ACTIONS	Character(1)	VARCHAR2(1) NOT NULL	IA Actions Y/N Table Edit Default Value: N
62	GVT_EXEC_FIN_DISCL	Character(1)	VARCHAR2(1) NOT NULL	Executive Financial Disclosure Y/N Table Edit Default Value: N
63	GVT_EMP_FIN_INT	Character(1)	VARCHAR2(1) NOT NULL	Employee Financial Interests Y/N Table Edit Default Value: N
64	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
65	GVT_CLS_STANDARD	Character(15)	VARCHAR2(15) NOT NULL	Classification Standard Prompt Table: GVT_CLS_STD_TBL
66	GVT_CLASSIFIER_ID	Character(11)	VARCHAR2(11) NOT NULL	Classifier's ID
67	GVT_DT_CLASSIFIED	Date(10)	DATE	Date Classified Default Value: %date
68	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2 Prompt Table: GVT_BARG_UNIT
69	GVT_FUND_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Fund Source A=Appropriated Funds E=External Funds N=Non-Appropriated Funds O=Other Funds
70	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
71	GVT_PERF_PLAN	Character(8)	VARCHAR2(8) NOT NULL	Performance Plan Prompt Table: GVT_PERF_PLAN
72	GVT_TARGET_GRADE	Character(2)	VARCHAR2(2) NOT NULL	Target Grade
73	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
74	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
75	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
76	GVT_NFC_PI_IND_OVR	Character(1)	VARCHAR2(1) NOT NULL	Federal NFC Field Y/N Table Edit Default Value: N
77	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
78	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
79	ENCUMBER_INDC	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Indicator I=Encumber Immediately N=No Encumbrance R=Encumber on Requisition Default Value: N
80	POSN_MGMT_INDC	Character(1)	VARCHAR2(1) NOT NULL	Used by Position Management Y/N Table Edit Default Value: Y
81	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank Prompt Table: EG_RANK_TBL
82	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group Prompt Table: EG_CALC_SVC_VW
83	HP_STATS_DUTIES	Character(2)	VARCHAR2(2) NOT NULL	Stats-Can Duties 10=Teaching Only 20=Teaching & Othr Responsibility 30=Research
84	HP_STATS_RPT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Stats-Can Report Flag B=Both Surveys F=Full-Time Survey N=Not Applicable P=Part-Time Survey Default Value: N
85	ENCUMB_SAL_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Encumber Salary Option COM=Sum of Default Components MAX=Salary Grade Maximum MID=Salary Grade Midpoint MIN=Salary Grade Minimum STP=Salary Step USR=User Specified Amount Default Value: STP
86	ENCUMB_SAL_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Encumber Salary Amount
87	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_STANDARD_VW
88	SAL_RANGE_MIN_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Salary Range Minimum Rate
89	SAL_RANGE_MID_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Salary Range Midpoint Rate
90	SAL_RANGE_MAX_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Salary Range Maximum Rate
91	SAL_RANGE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Salary Range Currency Prompt Table: CURRENCY_CD_TBL
92	SAL_RANGE_FREQ	Character(5)	VARCHAR2(5) NOT NULL	Salary Range Frequency Prompt Table: COMP_FREQ_VW
93	DESCRLONG	Long Character	CLOB	Long Description