| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GVT_STATUS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
|
| 3 |
GVT_WIP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Work-in-Progress Status
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 6 |
GVT_MPA_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Mass Pay Adjustment Type
FWA=Annual Federal Wage Service
FWS=FWS Special Rate Increase
GSA=GS Annual Pay Adjustment
GSS=GS Special Rate Increase
LEO=LEO Special Pay Adjustment
LPA=Locality Pay Adjustment
|
| 7 |
GVT_MPA_DATE |
Date(10) |
DATE |
GVT Mass Pay Adjustment EFFDT
|
| 8 |
ACTION_DT |
Date(10) |
DATE |
Action Date
|
| 9 |
GVT_MPA_PCT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GVT Mass Pay Adjustment Pct
|
| 10 |
GVT_MPA_PROC_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT Mass Pay Adj Process Act
P=Process Actions and Report
R=Generate Report Only
|
| 11 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
|
| 12 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
|
| 13 |
GVT_PAR_AUTH_D1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 1
|
| 14 |
GVT_PAR_AUTH_D1_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 1 Descr - Part 2
|
| 15 |
GVT_PAR_AUTH_D2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 1
|
| 16 |
GVT_PAR_AUTH_D2_2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Authority 2 Descr - Part 2
|
| 17 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 18 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
|
| 19 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
|
| 20 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 21 |
GVT_MPA_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Pay Adj Calc Type
P=Percentage
S=Special Calculation Routine
T=Pay Tables
|
| 22 |
GVT_MPA_SPEC_CALC |
Character(3) |
VARCHAR2(3) NOT NULL |
GVT Mass Pay Adjustment Spec
GM=GH/GM Special Calucation
|
| 23 |
GVT_MPA_TABLE_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Pay Adj Pay Tables
A=Include All for Pay Plan
E=Exclude Tables Listed
I=Include Tables Listed
|
| 24 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 25 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 26 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 27 |
GVT_RTND_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Retained Grade
|
| 28 |
GVT_RTND_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Retained Pay Plan
|
| 29 |
GVT_RTND_SAL_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Retained Pay Table
|
| 30 |
GVT_RTND_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Retained Step
|
| 31 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 32 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 33 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 34 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 35 |
GVT_PAY_RATE_DETER |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Rate Determinant
0=Regular Rate
2=Saved Rate - Indefinite
3=Retained Pay - Spec Rt Adjust
4=Saved Rate - Other
5=Special & Superior Quals
6=Special Rate
7=Superior Qualifications Rate
A=Retained Grade - Diff Posn
B=Retained Grade - Same Posn
C=Critical Position Pay
E=Rtnd Grd & Spec Rt - Diff Posn
F=Rtnd Grd & Spec Rt - Same Posn
J=Retained Pay - Same Position
K=Retained Pay - Diff Posn
M=Continued IGA Pay
M=Continued IGA Pay
P=Preserved IGA Pay
R=Retained Pay - SES Removal
S=Continued SES Basic Pay
T=Below the Minimum Rate
U=Rtnd Grade & Pay - Same Posn
V=Rtnd Grade & Pay - Diff Posn
Y=NSPS Retained Pay
Z=Border Equalization Allowance
|
| 36 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 37 |
ANNL_BEN_BASE_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Benefit Base Rate Override
|
| 38 |
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
|
| 39 |
GVT_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Comp Rate
|
| 40 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 41 |
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
|
| 42 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 43 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 44 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 45 |
ANNL_BENEF_BASE_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
|
| 46 |
GVT_LOCALITY_ADJ |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Locality Adjustment
|
| 47 |
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
|
| 48 |
GVT_STEP |
Character(2) |
VARCHAR2(2) NOT NULL |
US Federal Step
|
| 49 |
MESSAGE_WRITTEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Written
Default Value: N
|
| 50 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 51 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 52 |
REHIRE_DT |
Date(10) |
DATE |
Rehire Date
|
| 53 |
CMPNY_SENIORITY_DT |
Date(10) |
DATE |
Company Seniority Date
|
| 54 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 55 |
PROF_EXPERIENCE_DT |
Date(10) |
DATE |
Professional Experience Date
|
| 56 |
LAST_VERIFICATN_DT |
Date(10) |
DATE |
Last Verification Date
|
| 57 |
EXPECTED_RETURN_DT |
Date(10) |
DATE |
Expected Return Date
|
| 58 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 59 |
LAST_DATE_WORKED |
Date(10) |
DATE |
Last Date Worked
|
| 60 |
LAST_INCREASE_DT |
Date(10) |
DATE |
Date Last Increase
|
| 61 |
PROBATION_DT |
Date(10) |
DATE |
Probation Date
|
| 62 |
GVT_SCD_LEO |
Date(10) |
DATE |
Service Comp Date - LEO
|
| 63 |
GVT_SCD_RETIRE |
Date(10) |
DATE |
Service Comp Date - Retire
|
| 64 |
GVT_SCD_SEVPAY |
Date(10) |
DATE |
Service Comp Date - Sev Pay
|
| 65 |
GVT_SCD_TSP |
Date(10) |
DATE |
Service Comp Date - TSP
|
| 66 |
GVT_MAND_RET_DT |
Date(10) |
DATE |
Mandatory Retirement Date
|
| 67 |
GVT_TEMP_PRO_EXPIR |
Date(10) |
DATE |
Temp Promotion Expires
|
| 68 |
GVT_TEMP_PSN_EXPIR |
Date(10) |
DATE |
Temporary Posn Change Expires
|
| 69 |
GVT_DETAIL_EXPIRES |
Date(10) |
DATE |
Date Detail Expires
|
| 70 |
GVT_SABBATIC_EXPIR |
Date(10) |
DATE |
Date Sabbatical Expires
|
| 71 |
GVT_RTND_GRADE_BEG |
Date(10) |
DATE |
Retained Grade Begins
|
| 72 |
GVT_APPT_EXPIR_DT |
Date(10) |
DATE |
Appointment Expiration Date
|
| 73 |
GVT_CNV_BEGIN_DATE |
Date(10) |
DATE |
Conv Begin Date
|
| 74 |
GVT_CAREER_CNV_DUE |
Date(10) |
DATE |
Conversion To Career Due
|
| 75 |
GVT_CAREER_COND_DT |
Date(10) |
DATE |
Career Cond Conversion Date
|
| 76 |
GVT_SUPV_PROB_DT |
Date(10) |
DATE |
Supv/Manager Probation Date
|
| 77 |
GVT_SES_PROB_DT |
Date(10) |
DATE |
SES Probation Date
|
| 78 |
GVT_CLRNCE_STAT_DT |
Date(10) |
DATE |
Security Clearance Status Date
|
| 79 |
GVT_WGI_DUE_DATE |
Date(10) |
DATE |
Within-Grade Increase Due Date
|
| 80 |
GVT_DT_LEI |
Date(10) |
DATE |
Date Last Equivalent Increase
|
| 81 |
GVT_FIN_DISCL_DATE |
Date(10) |
DATE |
Financial Disclosure Due Date
|
| 82 |
UNION_SENIORITY_DT |
Date(10) |
DATE |
Union Seniority Date
|
| 83 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
C=Complete
V=Void
X=W-2c Issued
|
| 84 |
NEXT_REVIEW_DT |
Date(10) |
DATE |
Next Review Date
|
| 85 |
APPOINT_END_DT |
Date(10) |
DATE |
Appointment End Date
|
| 86 |
DUPLICATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Flag
Default Value: N
|
| 87 |
FUTURE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Future Flag
Default Value: N
|
| 88 |
SAMEDAY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action on Same Day
|
| 89 |
RATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Flag
|
| 90 |
HOURLY_FACTOR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hourly Factor Flag
|
| 91 |
RETAINED_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
for app engine fghr002b
|
| 92 |
PAY_RATE_DETER_AE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Rate Deter Variable
|
| 93 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 94 |
CURRENT_PAY_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Current Pay Grade
|
| 95 |
CURRENT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Current Pay Plan
|
| 96 |
CURRENT_PAY_STEP |
Number(2,0) |
SMALLINT NOT NULL |
Current Pay Step
|
| 97 |
CURRENT_PAY_TABLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Current Pay Table
|
| 98 |
GVT_COMPRATE_NOLOC |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
GVT New No Location Comprate
|
| 99 |
BASE_PAY_TABLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Base Pay Table
|
| 100 |
GVT_HRLY_CNV_FCTR |
Number(4,0) |
SMALLINT NOT NULL |
Hourly Rate Conv Factor
|
| 101 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 102 |
GVT_BIWEEKLY_RT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Biweekly Rate
|
| 103 |
MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Monthly Rate
|
| 104 |
ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate
|
| 105 |
GVT_INCREASE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Increase
|
| 106 |
MAX_RT_ANNUAL |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Maximum Pay Rate-Annual
|
| 107 |
MIN_RT_ANNUAL |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Minimum Pay Rate-Annual
|
| 108 |
PREV_EXCESS_OF_MIN |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Previous Excess of Min
|
| 109 |
PREV_RANGE_AMT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Previous Range Amount
|
| 110 |
PREV_FACTOR |
Number(12,0) |
DECIMAL(12) NOT NULL |
Previous Factor
|
| 111 |
CURR_RANGE_AMT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Current Range Amount
|
| 112 |
CURR_EXCESS_OF_MIN |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Current Excess Of Min
|
| 113 |
GVT_LOCALITY_PCT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Locality percentage
|
| 114 |
GVT_LEO_PCT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
LEO percentage
|
| 115 |
GVT_LEO_PCT_TEMP |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
LEO Percentage Temp Value
|
| 116 |
COMPRATE_NOLOC_NEW |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New No Location Comprate
|
| 117 |
HRLY_RT_NOLOC_NEW |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate No Location New
|
| 118 |
DAILY_RT_NOLOC_NEW |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Daily Rate No Location New
|
| 119 |
BIWK_RT_NOLOC_NEW |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Biweekly Rate No Location New
|
| 120 |
MONTH_RT_NOLOC_NEW |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Monthly Rate No Location New
|
| 121 |
ANNL_RT_NOLOC_NEW |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Annual Rate No Location New
|
| 122 |
GVT_LOCALITY_ADJ_N |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Locality Adjustment New
|
| 123 |
BASE_ANNL_LOC_ADJ |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Base Annual Location Adjust
|
| 124 |
MULT_PCT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Mulitple Percent
|
| 125 |
LOC_ADJUSTED_RATE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
for app engine fghr002b
|
| 126 |
BASE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro on Chg in Benefits Base
|
| 127 |
BASE_ANNUAL_RATE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Base Annual Rate
|
| 128 |
NEW_ANNL_B_BASE_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
|
| 129 |
NEW_CHANGE_AMT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
for app engine fghr002b
|
| 130 |
NEW_CHANGE_PCT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
for app engine fghr002b
|
| 131 |
COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 132 |
NEW_GVT_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New GVT Compensation Rate
|
| 133 |
NEW_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New Compensation Rate
|
| 134 |
NEW_HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
New Hourly Rate
|
| 135 |
NEW_DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
for app engine fghr002b
|
| 136 |
NEW_BIWEEKLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
for app engine fghr002b
|
| 137 |
NEW_MONTHLY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
for fghr002b
|
| 138 |
NEW_ANNUAL_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
for app engine fghr002b
|
| 139 |
JOB_EFFDT_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
New Job Effdt Date Match
|
| 140 |
NEW_EFFSEQ |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
For app engine fghr002b
|
| 141 |
NEW_TRANS_NBR |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
For app engine fghr002b
|
| 142 |
NEW_TRANS_NBR_SEQ |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
For app engine fghr002b
|
| 143 |
PAY_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
|
| 144 |
PAY_PERIOD_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Pay Period Hours
|
| 145 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 146 |
AMOUNT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Commuting Allowance Paid Per Cycle.
|
| 147 |
GVT_QUOTE_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Quoted annualized amount.
|
| 148 |
NEW_EARNS_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
New Earnings Amount
|
| 149 |
BASED_ON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Based on Type
A=Special Accumulator
N=Not Based On Another Earnings
S=Single Earnings
|
| 150 |
FACTOR_MULT |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Multiplication Factor
|
| 151 |
GVT_BENEFITS_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adds to FEGLI Base Rate
|
| 152 |
GVT_INCLUDE_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Locality Adjustment
|
| 153 |
ADD_TO_BASE |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Add To Base
|
| 154 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 155 |
GVT_INSERT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Insertion Required
|
| 156 |
GVT_CHECK_FCT |
Number(3,0) |
SMALLINT NOT NULL |
CHECK FCT
|
| 157 |
GVT_CHECK_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
CHECK GRADE
|
| 158 |
GVT_CHECK_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
CHECK PLAN
|
| 159 |
GVT_CHECK_STEP |
Number(2,0) |
SMALLINT NOT NULL |
CHECK STEP
|
| 160 |
GVT_LEO_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
LEO GRADE
|
| 161 |
GVT_LEO_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
LEO PLAN
|
| 162 |
GVT_LEO_STEP |
Number(2,0) |
SMALLINT NOT NULL |
LEO STEP
|
| 163 |
GVT_LOC_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
LOC GRADE
|
| 164 |
GVT_LOC_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
LOC PLAN
|
| 165 |
GVT_LOC_STEP |
Number(2,0) |
SMALLINT NOT NULL |
LOC STEP
|
| 166 |
GVT_PL_FCT |
Number(3,0) |
SMALLINT NOT NULL |
PL FACTOR
|
| 167 |
GVT_PL_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
PL GRADE
|
| 168 |
GVT_PL_LEO_FCT |
Number(3,0) |
SMALLINT NOT NULL |
PL LEO FACTOR
|
| 169 |
GVT_PL_LOC_FCT |
Number(3,0) |
SMALLINT NOT NULL |
PL LOC FACTOR
|
| 170 |
GVT_PL_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
PL PLAN
|
| 171 |
GVT_PL_STEP |
Number(2,0) |
SMALLINT NOT NULL |
PL STEP
|
| 172 |
GVT_PL_TABLE |
Character(4) |
VARCHAR2(4) NOT NULL |
PL TABLE
|
| 173 |
GVT_ANNL_PAY_LIMIT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
ANNUAL PAY LIMIT
|
| 174 |
SQL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
TL
|
| 175 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 176 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 177 |
GP_DFLT_EXRTDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
|
| 178 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 179 |
ANNL_RT_NOLOC_AE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Annual Rate No Location New
|
| 180 |
BIWEEKLY_RT_AE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
for app engine fghr002b
|
| 181 |
BIWK_RT_NOLOC_AE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Biweekly Rate No Location New
|
| 182 |
CHANGE_AMT_AE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
for app engine fghr002b
|
| 183 |
CHANGE_PCT_AE |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
for app engine fghr002b
|
| 184 |
DAILY_RT_AE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
for app engine fghr002b
|
| 185 |
DAILY_RT_NOLOC_AE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Daily Rate No Location New
|
| 186 |
EFFSEQ_AE |
Number(3,0) |
SMALLINT NOT NULL |
new_effseq_nbr
|
| 187 |
MONTH_RT_NOLOC_AE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Monthly Rate No Location New
|
| 188 |
TRANS_NBR_AE |
Number(1,0) |
SMALLINT NOT NULL |
New Trans Number
|
| 189 |
TRANS_NBR_SEQ_AE |
Number(1,0) |
SMALLINT NOT NULL |
New Trans Number Sequence
|
| 190 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 191 |
SELECTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selected Flag
|
| 192 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 193 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|