| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 5 |
BENEFIT_RCD_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
|
| 6 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 7 |
PRIOR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Prior Emplid
|
| 8 |
PRIOR_EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Prior Employee Record Number
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 10 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 11 |
PGM_FLOW_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Convenient AE State Record field for receiving result of a Do-When, Do-While, Do-Until, or other program flow control flag.
|
| 12 |
FORM_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Form Identification
|
| 13 |
LAST_FORM_USED |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Form Number Used
|
| 14 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 15 |
FSA_RUN_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Flexible Spending Acct Run ID
|
| 16 |
CHECK_DT |
Date(10) |
DATE |
Check date.
|
| 17 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 18 |
END_DT |
Date(10) |
DATE |
end date
|
| 19 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck number.
|
| 20 |
ANNUAL_PLEDGE |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Annual Pledge
|
| 21 |
FSA_APR_AMT_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Approved Amount YTD
|
| 22 |
FSA_CLAIM_NBR_LAST |
Number(8,0) |
INTEGER NOT NULL |
Last FSA Claim # Assigned
|
| 23 |
CLAIMID |
Character(8) |
VARCHAR2(8) NOT NULL |
Claim ID
|
| 24 |
AMT_AVAIL |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Approved Amount YTD
|
| 25 |
FSA_MIN_CHECK_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
FSA Minimum Check Amount
|
| 26 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 27 |
FSA_PD_AMT_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Paid Amount YTD
|
| 28 |
CONTRIB_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Annual Pledge
|
| 29 |
FSA_PAYMENT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Annual Pledge
|
| 30 |
AMT_LEFT_TO_PAY |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Approved Amount YTD
|
| 31 |
CHECK_AMT |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Approved Amount YTD
|
| 32 |
FULL_AMT_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 33 |
FSA_CLAIM_APR_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Claim Approved Amount
|
| 34 |
FSA_CLAIM_SUB_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Claim Submitted Amount
|
| 35 |
APR_AMOUNT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
FSA Approved Amount YTD
|
| 36 |
BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 37 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 38 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 39 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
|
| 40 |
SRVC_DT_FROM |
Date(10) |
DATE |
FSA Service From Date
|
| 41 |
SRVC_DT_THRU |
Date(10) |
DATE |
FSA Service To Date
|
| 42 |
SVC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Type
C=Dependent Day Care
D=Dental
H=Hearing
M=Medical
O=Orthodontia
P=Prescription Drugs
R=Retirement Counselling
V=Vision
Y=Carryforward
|
| 43 |
CLAIM_PAYMENT |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Annual Pledge
|
| 44 |
PRIOR_CLAIMID |
Character(8) |
VARCHAR2(8) NOT NULL |
Claim ID
|
| 45 |
FSA_CLAIM_DENY_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Claim Denied Amount
|
| 46 |
FSA_CLAIM_DENY_RSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Denied Reason
A=Alredy Paid
N=Not a Covered Expense
P=Claim Pended-Exceeds Avail Bal
X=Submitted Amt Exceeds Balance
|
| 47 |
FSA_CLAIM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FSA Claim Status
F=Fully Processed
J=Rejected
P=Pended
R=Ready To Pay
S=Submitted
X=Reversed Claim
|
| 48 |
FSA_SPLIT_CLAIMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Split Claims
|
| 49 |
SVC_FROM_DT |
Date(10) |
DATE |
Service From Date
|
| 50 |
FSA_SUB_AMT_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Submitted Amount YTD
|
| 51 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 52 |
PRIOR_CHECK_DT |
Date(10) |
DATE |
Check date.
|
| 53 |
PRIOR_CALENDAR_YR |
Number(4,0) |
SMALLINT NOT NULL |
Prior Calendar Year
|
| 54 |
PRIOR_FORM_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Form Identification
|
| 55 |
PRIOR_BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Prior benefit Plan
|
| 56 |
PRIOR_BENEFIT_PGM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 57 |
PRIOR_PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
This is an internal work field used to record the value of the PLAN_TYPE field before a change. Upon SAVE, this field is compared to the current PLAN_TYPE field to determine if special procesing should be invoked.
|
| 58 |
APR_BALANCE |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
FSA Approved Amount YTD
|
| 59 |
PRIOR_DENY_AMT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Claim Denied Amount
|
| 60 |
DRAW_FROM_PLEDGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Convenient AE State Record field for receiving result of a Do-When, Do-While, Do-Until, or other program flow control flag.
|
| 61 |
EMPLR_CONTRBUTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer Contribution
1=Flat Amount
2=Percent of Employee Contrbutn
3=Special Calculation Routine
4=None
|
| 62 |
EMPLR_CONTRB_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Employer Contrib Limit Amt
|
| 63 |
EMPLR_CONTRB_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Employer Contribution Limit %
|
| 64 |
FLAT_CONTRB_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Flat Contribution Amount
|
| 65 |
PCT_EMPL_CONTRBUTN |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Percent of Employee Contributn
|
| 66 |
ADD_PLEDGE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Annual Pledge
|
| 67 |
FSA_PAYMENT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FSA Payment Status
P=Paid
R=Pay This Run
V=Void Check
X=Reversed Check
|
| 68 |
FSA_CHECK_AMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
FSA Check Amount
|
| 69 |
FSA_ORIG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FSA Original Status
F=Fully Processed
J=Rejected
P=Pended
R=Ready To Pay
S=Submitted
X=Reversed Claim
|
| 70 |
FSA_CLAIM_PD_TO_DT |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
FSA Claim Paid To Date
|
| 71 |
FSA_CARRYOVER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
FSA carryover indicator of y/n which will be used within the FSA AE programs
|
| 72 |
FSA_CARRYOVER_LMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
The field will contain the carryover limit for health spending accounts
|
| 73 |
FSA_CARRYOVER_AMT |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
employee annual carryover amount which cannot exceed the FSA carryover limit. This amount is display only on the ee Spending account page.
|
| 74 |
FSA_CARRYOVER_CALC |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
This is the calculated carryover amount. The calculation is done in the current year and the value becomes (minus carryover amount already used fsa_carry_used) carryover amount for the new year.
|
| 75 |
FSA_CARRY_USED |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
The amount the carryover that is used prior to moving the carryover amount into the new year.
|
| 76 |
NEWYEAR_BEGIN_DT |
Date(10) |
DATE |
The begin date for the upcoming plan year
|
| 77 |
NEWYEAR_END_DT |
Date(10) |
DATE |
The upcoming plan year end date
|
| 78 |
AMT_LEFT_TO_CARRY |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Amount left in ee spending account and used to determine how much will carryover into the new plan year
|
| 79 |
FSA_CARRY_OVERRIDE |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
This FSA override amount can override the ee FSA carryover amount on the ee Spending account page.
|
| 80 |
FSA_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
FSA Close
|
| 81 |
RUNCNTRL_YR |
Number(4,0) |
SMALLINT NOT NULL |
RIn control year used to process FSA reversal
|
| 82 |
RUNCNTRL_DT |
Date(10) |
DATE |
used for FSA reversal
|
| 83 |
PRIORYEAR |
Number(4,0) |
SMALLINT NOT NULL |
prior year value
|
| 84 |
PRIORYEAR_BEGIN_DT |
Date(10) |
DATE |
prior year begin date
|
| 85 |
PRIORYEAR_END_DT |
Date(10) |
DATE |
prior year end date
|
| 86 |
PRIORYR_PD_AMT_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
prior year paid amount YTD
|
| 87 |
PRIORYR_PLEDGE |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
prior year annual pledge
|
| 88 |
LEFT_IN_PRIORYR |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
amount of FSA money left in prior year
|
| 89 |
FSA_AMT_NEEDED |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
amount of FSA money needed to process current year claim
|
| 90 |
FSA_ADJUST_YTD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
The FSA ytd adjustment amount
|
| 91 |
FSA_CARRY_PRIORYR |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Carryover amount coming from the prior year
|
| 92 |
COVERAGE_BEGIN_DT |
Date(10) |
DATE |
Coverage Begin Date
|
| 93 |
CARRY_NEWYEAR |
Number(4,0) |
SMALLINT NOT NULL |
New Year value for carryover
|