| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SCC_SEQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence ID
|
| 3 |
SCC_SEQ_ID3 |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Nbr
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
GVT_CRED_MIL_SVCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Creditable Military Service
|
| 7 |
GVT_MILITARY_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Uniformed Service
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
|
| 8 |
GVT_MIL_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Grade
E1=E1
E2=E2
E3=E3
E4=E4
E5=E5
E6=E6
E7=E7
E8=E8
E9=E9
O1=O1
O10=O10
O2=O2
O3=O3
O4=O4
O5=O5
O6=O6
O7=O7
O8=O8
O9=O9
W1=W1
W2=W2
W3=W3
W4=W4
|
| 9 |
GVT_MIL_RESRVE_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserve Category
A=IMA - Air Force
B=IMA - Army
C=IMA - Coast Guard
D=IMA - Marines
E=IMA - Navy
F=Selected Reserve - Air Force
G=Selected Reserve - Army
H=Selected Reserve - Coast Guard
I=Selected Reserve - Marine Corp
J=Selected Reserves - Navy
K=Air National Guard
L=Army National Guard
M=IRR - Air Force
N=IRR - Army
O=IRR - Coast Guard
P=IRR - Marine Corps
Q=IRR - Navy
S=Standby Reserve - Air Force
T=Standby Reserve - Army
U=Standby Reserve - Coast Guard
V=Standby Reserve - Marine Corps
W=Standby Reserve - Navy
X=Navy Reserve - Merchant Marine
Y=Draft Eligible
Z=Not Applicable
|
| 10 |
GVT_MIL_SEP_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
|
| 11 |
GVT_MIL_SVCE_END |
Date(10) |
DATE |
Military Service End Date
|
| 12 |
GVT_MIL_SVCE_START |
Date(10) |
DATE |
Military Service Start Date
|
| 13 |
GVT_MIL_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Service Verified
|
| 14 |
GVT_PAR_NBR_LAST |
Number(6,0) |
INTEGER NOT NULL |
Last Personnel Action Reqst #
|
| 15 |
GVT_UNIF_SVC_CTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Military Pay Center
|
| 16 |
GVT_VET_PREF_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference
|
| 17 |
GVT_VET_PREF_RIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference RIF
Default Value: N
|
| 18 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
|
| 19 |
GVT_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
|
| 20 |
GVT_YR_ATTAINED |
Date(10) |
DATE |
Year Attained
|
| 21 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
Y/N Table Edit
|
| 22 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Default Value: N
|
| 23 |
GVT_DISABILITY_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Code
Default Value: 05
|
| 24 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 25 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Default Value: 0000
|
| 26 |
GVT_CURR_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Agency Employee
Y/N Table Edit
Default Value: N
|
| 27 |
GVT_CURR_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Federal Employee
Y/N Table Edit
Default Value: N
|
| 28 |
GVT_HIGH_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Pay Plan
|
| 29 |
GVT_HIGH_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Grade
|
| 30 |
GVT_PREV_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Agency Employee
Y/N Table Edit
Default Value: N
|
| 31 |
GVT_PREV_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Federal Employee
Y/N Table Edit
Default Value: N
|
| 32 |
GVT_SEP_INCENTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive
|
| 33 |
GVT_SEP_INCENT_DT |
Date(10) |
DATE |
Separation Incentive Date
|
| 34 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 35 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 36 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 37 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|