UPG_POSNDTA_AET (SQL Table)	Index Back
UPG_POSNDTA_TMP UPG_POSNDTA_TMP is copy of POSITION_DATA for use during upgrade data conversion of FLSA_STATUS field for the Alternative Overtime feature.

UPG_POSNDTA_AET

(SQL Table)

UPG_POSNDTA_TMP

UPG_POSNDTA_TMP is copy of POSITION_DATA for use during upgrade data conversion of FLSA_STATUS field for the Alternative Overtime feature.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

3 EFFDT Date(10) DATE Effective Date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 ACTION Character(3) VARCHAR2(3) NOT NULL Action

8 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

9 ACTION_DT Date(10) DATE Action Date

10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

13 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen

14 STATUS_DT Date(10) DATE Status Date

15 BUDGETED_POSN Character(1) VARCHAR2(1) NOT NULL Budgeted Position

16 CONFIDENTIAL_POSN Character(1) VARCHAR2(1) NOT NULL Confidential Position

17 KEY_POSITION Character(1) VARCHAR2(1) NOT NULL Key Position

18 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted

19 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count

20 UPDATE_INCUMBENTS Character(1) VARCHAR2(1) NOT NULL Update Incumbents

21 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

22 REPORT_DOTTED_LINE Character(8) VARCHAR2(8) NOT NULL Dotted-Line Report

23 ORGCODE Character(60) VARCHAR2(60) NOT NULL Organization Hierarchy Code

24 ORGCODE_FLAG Character(1) VARCHAR2(1) NOT NULL Organization Hierarchy Flag

25 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

26 MAIL_DROP Character(50) VARCHAR2(50) NOT NULL Mail Drop ID

27 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

28 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

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

30 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

31 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

32 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

33 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=1
2=2
3=3
A=Any
C=Compressed
N=Not Applicable
R=Rotating

34 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

35 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

36 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday

37 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday

38 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday

39 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday

40 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday

41 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday

42 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday

43 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
Default Value: 8888
Prompt Table: GVT_BARG_UNIT

44 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
Prompt Table: GVT_PAY_PLAN

45 SEASONAL Character(1) VARCHAR2(1) NOT NULL Seasonal
Y/N Table Edit
Default Value: N

46 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program
Prompt Table: TRN_PROGRM_TBL

47 LANGUAGE_SKILL Character(2) VARCHAR2(2) NOT NULL Language Required

48 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

49 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status field
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

50 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status

51 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
CAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress

52 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
S=Part-Time Job Sharer
T=Part-Time Seasonal Job Sharer
Default Value: F

53 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
Prompt Table: GVT_SUBAGCY_TBL

54 GVT_DT_POSN_ESTAB Date(10) DATE Date Position Established
Default Value: %date

55 GVT_COMP_AREA Character(2) VARCHAR2(2) NOT NULL Competitive Area

56 GVT_COMP_LEVEL Character(4) VARCHAR2(4) NOT NULL Competitive Level

57 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Cd
Prompt Table: GVT_ORG_PSN_TTL

58 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title

59 GVT_DRUG_TEST_REQ Character(1) VARCHAR2(1) NOT NULL Drug Test (Applicable)
Default Value: N

60 GVT_FUND_SOURCE Character(1) VARCHAR2(1) NOT NULL Fund Source
A=Appropriated Funds
E=External Funds
N=Non-Appropriated Funds
O=Other Funds
Default Value: A

61 GVT_INTEL_POSN Character(1) VARCHAR2(1) NOT NULL Intelligence Position
Default Value: N

62 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
Default Value: N

63 GVT_MOB_POSN_IND Character(1) VARCHAR2(1) NOT NULL Mobility Position
Y/N Table Edit
Default Value: N

64 GVT_PROC_INTEG_PSN Character(1) VARCHAR2(1) NOT NULL Procurement Integ Posn
Y/N Table Edit
Default Value: N

65 GVT_PRESIDENT_APPT Character(1) VARCHAR2(1) NOT NULL Presidential Appt Posn
Y/N Table Edit
Default Value: N

66 GVT_NTE_DATE Date(10) DATE Not To Exceed Date

67 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
Prompt Table: GVT_OCCUPATION

68 GVT_PAR_NBR Character(15) VARCHAR2(15) NOT NULL Personnel Action Request Nbr

69 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title
D=(Data Transcribing)
O=(Office Automation)
S=(Stenography)
T=(Typing)

70 GVT_PERF_PLAN Character(8) VARCHAR2(8) NOT NULL Performance Plan
Prompt Table: GVT_PERF_PLAN

71 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
Prompt Table: GVT_POI_VW

72 GVT_POSN_LOC Character(1) VARCHAR2(1) NOT NULL Position Location
F=Field
H=Headquarters
Default Value: H

73 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved

74 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

75 GVT_STAFF_LINE Character(1) VARCHAR2(1) NOT NULL Staff/Line Position

76 GVT_LAST_AUDIT_DT Date(10) DATE Position Audit Date

77 GVT_AUDITED_BY_ID Character(11) VARCHAR2(11) NOT NULL Position Audited By
Prompt Table: PERSON_NAME

78 GVT_OBLIGATED_TO Character(11) VARCHAR2(11) NOT NULL Obligated To ID
Prompt Table: PERSON_NAME

79 GVT_OBLIG_EXPIR_DT Date(10) DATE Obligation Expiration

80 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade

81 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

82 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure
Default Value: N

83 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

84 GVT_MAINT_REVIEWCD Character(2) VARCHAR2(2) NOT NULL Federal field used by position data
0=None
1=Desk Audit, Normal Review
2=Suprvsry Audit,Normal Review
3=Paper Review, Normal Review
4=PME/Activity Review
5=Desk Audit, Maintenance Rev
6=Suprvsry Audit,Maintenance Rev
7=Paper Review,Maintenance Rev
8=Panel Review,Maintenance Rev
Default Value: 0

85 GVT_MANTREV_RESULT Character(2) VARCHAR2(2) NOT NULL Field used by federal customers on position data
0=None
1=No Action Required
2=Minor Description Changes
3=Rewrite of Position Descr Req
4=Position Title Change
5=Occupational Series Change
6=Position Upgrade
7=Position Downgraded
8=New Position
9=Other
Default Value: 0

86 GVT_VACY_REVW_CD Character(2) VARCHAR2(2) NOT NULL Federal field on position data
0=Position Action No Vacancy
A=No Change
B=Lower Grade
C=Higher Grade
D=Diff Title and/or Series
E=New Position/New FTE
Default Value: 0

87 GVT_ORG_SUBAGENCY Character(2) VARCHAR2(2) NOT NULL Federal field used in Position Data
Prompt Table: GVT_SUBAGCY_VW

88 GVT_ORG_NUMCD1 Number(2,0) SMALLINT NOT NULL Federal NFC Field

89 GVT_ORG_NUMCD2 Number(2,0) SMALLINT NOT NULL Federal NFC Field

90 GVT_ORG_NUMCD3 Number(4,0) SMALLINT NOT NULL Federal NFC Field

91 GVT_ORG_NUMCD4 Number(2,0) SMALLINT NOT NULL Federal NFC Field

92 GVT_ORG_NUMCD5 Number(2,0) SMALLINT NOT NULL Federal NFC Field

93 GVT_ORG_NUMCD6 Number(2,0) SMALLINT NOT NULL Federal NFC Field

94 GVT_ORG_NUMCD7 Number(2,0) SMALLINT NOT NULL Federal NFC Field

95 GVT_NFC_PI_IND_OVR Character(1) VARCHAR2(1) NOT NULL Federal NFC Field
Y/N Table Edit
Default Value: N

96 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

97 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Indc
B=All
C=Classified
T=Temporary
U=Unclassified

98 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
I=Encumber Immediately
N=No Encumbrance
R=Encumber on Requisition

99 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

100 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

101 EG_ACADEMIC_RANK Character(3) VARCHAR2(3) NOT NULL Academic Rank

102 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group

103 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

104 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

105 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount

106 HEALTH_CERTIFICATE Character(1) VARCHAR2(1) NOT NULL Health Certificate
1=Full Health Check
2=Eye Check
3=Ear Check
4=Radiation Check

107 SIGN_AUTHORITY Character(1) VARCHAR2(1) NOT NULL Signature Authority
1=Credit Competence
2=Signature Competence
3=Procuration

108 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

109 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

110 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

111 GRADE_FROM Character(3) VARCHAR2(3) NOT NULL From Grade
Prompt Table: SAL_GRADE_TBL

112 STEP_FROM Number(2,0) SMALLINT NOT NULL Step
Prompt Table: SAL_STEP_FRM_VW

113 GRADE_TO Character(3) VARCHAR2(3) NOT NULL To Grade
Prompt Table: SAL_GRADE_TBL

114 STEP_TO Number(2,0) SMALLINT NOT NULL Step
Prompt Table: SAL_STEP_TO_VW

115 STEP Number(2,0) SMALLINT NOT NULL Step

116 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID

117 PKG_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Sal Package - Package Template ID
Prompt Table: PKG_TMP_TBL

118 PKG_RULE_ID Character(10) VARCHAR2(10) NOT NULL Sal Package - Package Rule ID
Prompt Table: PKG_RULE_TBL

119 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system

120 INCLUDE_SALPLN_FLG Character(1) VARCHAR2(1) NOT NULL Include Salary Plan/Grade

121 DESCRLONG Long Character CLOB Long Description

122 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

123 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

124 SEC_CLEARANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Security Clearance Type

125 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

126 MIL_SVC_COMP_CD Character(4) VARCHAR2(4) NOT NULL Service Component

127 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
3	EFFDT	Date(10)	DATE	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
8	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
9	ACTION_DT	Date(10)	DATE	Action Date
10	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
13	POSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Position Status A=Approved P=Proposed R=Frozen
14	STATUS_DT	Date(10)	DATE	Status Date
15	BUDGETED_POSN	Character(1)	VARCHAR2(1) NOT NULL	Budgeted Position
16	CONFIDENTIAL_POSN	Character(1)	VARCHAR2(1) NOT NULL	Confidential Position
17	KEY_POSITION	Character(1)	VARCHAR2(1) NOT NULL	Key Position
18	JOB_SHARE	Character(1)	VARCHAR2(1) NOT NULL	Job Sharing Permitted
19	MAX_HEAD_COUNT	Number(4,0)	SMALLINT NOT NULL	Max Head Count
20	UPDATE_INCUMBENTS	Character(1)	VARCHAR2(1) NOT NULL	Update Incumbents
21	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
22	REPORT_DOTTED_LINE	Character(8)	VARCHAR2(8) NOT NULL	Dotted-Line Report
23	ORGCODE	Character(60)	VARCHAR2(60) NOT NULL	Organization Hierarchy Code
24	ORGCODE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Organization Hierarchy Flag
25	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
26	MAIL_DROP	Character(50)	VARCHAR2(50) NOT NULL	Mail Drop ID
27	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
28	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
29	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
30	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
31	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
32	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
33	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating
34	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
35	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
36	MON_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Monday
37	TUES_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Tuesday
38	WED_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Wednesday
39	THURS_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Thursday
40	FRI_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Friday
41	SAT_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Saturday
42	SUN_HRS	Number(5,2)	DECIMAL(4,2) NOT NULL	Sunday
43	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2 Default Value: 8888 Prompt Table: GVT_BARG_UNIT
44	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan Prompt Table: GVT_PAY_PLAN
45	SEASONAL	Character(1)	VARCHAR2(1) NOT NULL	Seasonal Y/N Table Edit Default Value: N
46	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program Prompt Table: TRN_PROGRM_TBL
47	LANGUAGE_SKILL	Character(2)	VARCHAR2(2) NOT NULL	Language Required
48	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
49	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status field 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
50	GVT_WIP_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Work-in-Progress Status
51	GVT_STATUS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Status Type CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress
52	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 S=Part-Time Job Sharer T=Part-Time Seasonal Job Sharer Default Value: F
53	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency Prompt Table: GVT_SUBAGCY_TBL
54	GVT_DT_POSN_ESTAB	Date(10)	DATE	Date Position Established Default Value: %date
55	GVT_COMP_AREA	Character(2)	VARCHAR2(2) NOT NULL	Competitive Area
56	GVT_COMP_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Competitive Level
57	GVT_ORG_TTL_CD	Character(4)	VARCHAR2(4) NOT NULL	Organization Posn Title Cd Prompt Table: GVT_ORG_PSN_TTL
58	GVT_ORG_TTL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Organization Position Title
59	GVT_DRUG_TEST_REQ	Character(1)	VARCHAR2(1) NOT NULL	Drug Test (Applicable) Default Value: N
60	GVT_FUND_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Fund Source A=Appropriated Funds E=External Funds N=Non-Appropriated Funds O=Other Funds Default Value: A
61	GVT_INTEL_POSN	Character(1)	VARCHAR2(1) NOT NULL	Intelligence Position Default Value: N
62	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 Default Value: N
63	GVT_MOB_POSN_IND	Character(1)	VARCHAR2(1) NOT NULL	Mobility Position Y/N Table Edit Default Value: N
64	GVT_PROC_INTEG_PSN	Character(1)	VARCHAR2(1) NOT NULL	Procurement Integ Posn Y/N Table Edit Default Value: N
65	GVT_PRESIDENT_APPT	Character(1)	VARCHAR2(1) NOT NULL	Presidential Appt Posn Y/N Table Edit Default Value: N
66	GVT_NTE_DATE	Date(10)	DATE	Not To Exceed Date
67	GVT_OCC_SERIES	Character(4)	VARCHAR2(4) NOT NULL	Occupational Series Prompt Table: GVT_OCCUPATION
68	GVT_PAR_NBR	Character(15)	VARCHAR2(15) NOT NULL	Personnel Action Request Nbr
69	GVT_PAREN_TITLE	Character(1)	VARCHAR2(1) NOT NULL	Parenthetical Title D=(Data Transcribing) O=(Office Automation) S=(Stenography) T=(Typing)
70	GVT_PERF_PLAN	Character(8)	VARCHAR2(8) NOT NULL	Performance Plan Prompt Table: GVT_PERF_PLAN
71	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID Prompt Table: GVT_POI_VW
72	GVT_POSN_LOC	Character(1)	VARCHAR2(1) NOT NULL	Position Location F=Field H=Headquarters Default Value: H
73	GVT_POSN_OCCUPIED	Character(1)	VARCHAR2(1) NOT NULL	Position Occupied 1=Competitive 2=Excepted 3=SES General 4=SES Career Reserved
74	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
75	GVT_STAFF_LINE	Character(1)	VARCHAR2(1) NOT NULL	Staff/Line Position
76	GVT_LAST_AUDIT_DT	Date(10)	DATE	Position Audit Date
77	GVT_AUDITED_BY_ID	Character(11)	VARCHAR2(11) NOT NULL	Position Audited By Prompt Table: PERSON_NAME
78	GVT_OBLIGATED_TO	Character(11)	VARCHAR2(11) NOT NULL	Obligated To ID Prompt Table: PERSON_NAME
79	GVT_OBLIG_EXPIR_DT	Date(10)	DATE	Obligation Expiration
80	GVT_TARGET_GRADE	Character(2)	VARCHAR2(2) NOT NULL	Target Grade
81	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
82	GVT_EXEC_FIN_DISCL	Character(1)	VARCHAR2(1) NOT NULL	Executive Financial Disclosure Default Value: N
83	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
84	GVT_MAINT_REVIEWCD	Character(2)	VARCHAR2(2) NOT NULL	Federal field used by position data 0=None 1=Desk Audit, Normal Review 2=Suprvsry Audit,Normal Review 3=Paper Review, Normal Review 4=PME/Activity Review 5=Desk Audit, Maintenance Rev 6=Suprvsry Audit,Maintenance Rev 7=Paper Review,Maintenance Rev 8=Panel Review,Maintenance Rev Default Value: 0
85	GVT_MANTREV_RESULT	Character(2)	VARCHAR2(2) NOT NULL	Field used by federal customers on position data 0=None 1=No Action Required 2=Minor Description Changes 3=Rewrite of Position Descr Req 4=Position Title Change 5=Occupational Series Change 6=Position Upgrade 7=Position Downgraded 8=New Position 9=Other Default Value: 0
86	GVT_VACY_REVW_CD	Character(2)	VARCHAR2(2) NOT NULL	Federal field on position data 0=Position Action No Vacancy A=No Change B=Lower Grade C=Higher Grade D=Diff Title and/or Series E=New Position/New FTE Default Value: 0
87	GVT_ORG_SUBAGENCY	Character(2)	VARCHAR2(2) NOT NULL	Federal field used in Position Data Prompt Table: GVT_SUBAGCY_VW
88	GVT_ORG_NUMCD1	Number(2,0)	SMALLINT NOT NULL	Federal NFC Field
89	GVT_ORG_NUMCD2	Number(2,0)	SMALLINT NOT NULL	Federal NFC Field
90	GVT_ORG_NUMCD3	Number(4,0)	SMALLINT NOT NULL	Federal NFC Field
91	GVT_ORG_NUMCD4	Number(2,0)	SMALLINT NOT NULL	Federal NFC Field
92	GVT_ORG_NUMCD5	Number(2,0)	SMALLINT NOT NULL	Federal NFC Field
93	GVT_ORG_NUMCD6	Number(2,0)	SMALLINT NOT NULL	Federal NFC Field
94	GVT_ORG_NUMCD7	Number(2,0)	SMALLINT NOT NULL	Federal NFC Field
95	GVT_NFC_PI_IND_OVR	Character(1)	VARCHAR2(1) NOT NULL	Federal NFC Field Y/N Table Edit Default Value: N
96	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
97	CLASS_INDC	Character(1)	VARCHAR2(1) NOT NULL	Classified/Unclassified Indc B=All C=Classified T=Temporary U=Unclassified
98	ENCUMBER_INDC	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Indicator I=Encumber Immediately N=No Encumbrance R=Encumber on Requisition
99	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
100	POSITION_POOL_ID	Character(3)	VARCHAR2(3) NOT NULL	Position Pool ID
101	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank
102	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group
103	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
104	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
105	ENCUMB_SAL_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Encumber Salary Amount
106	HEALTH_CERTIFICATE	Character(1)	VARCHAR2(1) NOT NULL	Health Certificate 1=Full Health Check 2=Eye Check 3=Ear Check 4=Radiation Check
107	SIGN_AUTHORITY	Character(1)	VARCHAR2(1) NOT NULL	Signature Authority 1=Credit Competence 2=Signature Competence 3=Procuration
108	ADDS_TO_FTE_ACTUAL	Character(1)	VARCHAR2(1) NOT NULL	Adds to FTE Actual Count
109	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
110	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
111	GRADE_FROM	Character(3)	VARCHAR2(3) NOT NULL	From Grade Prompt Table: SAL_GRADE_TBL
112	STEP_FROM	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: SAL_STEP_FRM_VW
113	GRADE_TO	Character(3)	VARCHAR2(3) NOT NULL	To Grade Prompt Table: SAL_GRADE_TBL
114	STEP_TO	Number(2,0)	SMALLINT NOT NULL	Step Prompt Table: SAL_STEP_TO_VW
115	STEP	Number(2,0)	SMALLINT NOT NULL	Step
116	JOB_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	Job Profile ID
117	PKG_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sal Package - Package Template ID Prompt Table: PKG_TMP_TBL
118	PKG_RULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sal Package - Package Rule ID Prompt Table: PKG_RULE_TBL
119	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
120	INCLUDE_SALPLN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Salary Plan/Grade
121	DESCRLONG	Long Character	CLOB	Long Description
122	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
123	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
124	SEC_CLEARANCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Security Clearance Type
125	MILITARY_SERVICE	Character(8)	VARCHAR2(8) NOT NULL	Military Service
126	MIL_SVC_COMP_CD	Character(4)	VARCHAR2(4) NOT NULL	Service Component
127	MIL_RANK	Character(5)	VARCHAR2(5) NOT NULL	Military Rank