| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Type
Prompt Table:
PRCSTYPE_VW
|
| 4 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 5 |
CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
Prompt Table:
%CALC_PROMPT
|
| 6 |
CALC_SEQ_NUM |
Number(9,0) |
DECIMAL(9) NOT NULL |
Calc Seq Num
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EMP_PROMPT
|
| 8 |
EMPLID_RET_PYMNT |
Character(11) |
VARCHAR2(11) NOT NULL |
Payee EmplID
|
| 9 |
EMPLID_WITHDRAW |
Character(11) |
VARCHAR2(11) NOT NULL |
Payee EmplID
|
| 10 |
GROUP_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Group Name
Prompt Table:
PA_CLC_CUSTM_VW
|
| 11 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
%BEN_PLAN_EDIT
|
| 12 |
SPOUSE_CONSENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Spousal Consent Form Included
Y/N Table Edit
Default Value: N
|
| 13 |
EXPL_OF_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Explanation of Optional Forms
Y/N Table Edit
Default Value: N
|
| 14 |
SINGLE_CERTIFICATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Certification of Single Status
Y/N Table Edit
|
| 15 |
REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
D=Detailed
N=Non Detailed
|
| 16 |
MAR_STATUS_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status Form
Y/N Table Edit
|
| 17 |
RUN_CNTL_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Control Work
|
| 18 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 19 |
PRIOR_VAL_DATE |
Date(10) |
DATE |
Prior Actuarial Valuation Date
|
| 20 |
SVC_FUNCTN_RESULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Benefit Service Functn Result
Prompt Table:
PA_DFN_SVC_VW
|
| 21 |
VST_FUNCTN_RESULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Vesting Service Functn Result
Prompt Table:
PA_DFN_SVC_VW
|
| 22 |
ERN_FUNCTN_RESULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Cons Earnings Functn Result
Prompt Table:
PA_CONS_EARN_VW
|
| 23 |
HRS_FUNCTN_RESULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Cons Hours Functn Result
Prompt Table:
PA_CONS_HRS_VW
|
| 24 |
ACT_FUNCTN_RESULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Balance Functn Result
Prompt Table:
PA_DFN_EACC_VW
|
| 25 |
PERIODIC_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Periodic Cycle
A=Annual Cycle
M=Monthly Cycle
Q=Quarterly Cycle
|
| 26 |
POPULATION_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Population code
A=All Employees
G=Pre-defined Group
I=Individual
L=Pre-defined Employee List
Default Value: I
|
| 27 |
CALC_ALL_PLANS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate All Plans
Y/N Table Edit
Default Value: N
|
| 28 |
ALL_PLANS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Benefit Plan
N=
Y=All Plans Selected
Default Value: PA_RT_CAL_ACT_V.ALL_PLANS_CD
|
| 29 |
MIN_BEN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Benefit Process
Default Value: N
|
| 30 |
ACCT_BAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Account Balances
Y/N Table Edit
Default Value: N
|
| 31 |
CASH_BAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Balances
Y/N Table Edit
Default Value: N
|
| 32 |
SERVICE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Service
Y/N Table Edit
Default Value: N
|
| 33 |
PARTIC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Participation
Y/N Table Edit
Default Value: N
|
| 34 |
PLAN_DATES_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Dates
Y/N Table Edit
Default Value: N
|
| 35 |
PAYROLL_HIST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll History
Y/N Table Edit
Default Value: N
|
| 36 |
EXT_EMP_DATA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
External Employee Data
Y/N Table Edit
Default Value: N
|
| 37 |
CONS_HRS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Hours
Y/N Table Edit
Default Value: N
|
| 38 |
CONS_EARN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Earnings
Y/N Table Edit
Default Value: N
|
| 39 |
CONS_CONTRIB_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Contributions
Y/N Table Edit
Default Value: N
|
| 40 |
PENSION_ST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Status Indicator
Y/N Table Edit
Default Value: N
|
| 41 |
DELETE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Indicator is used to indicate whether a row has been logically deleted.
Y/N Table Edit
Default Value: N
|
| 42 |
FUNCTN_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
Prompt Table:
PA_CLC_SET_VW
|
| 43 |
PROCESS_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Periodic Processing Mode
C=Create New Consolidations
P=Normal Processing
R=Delete and Rebuild
Default Value: P
|
| 44 |
PYMT_FREQ |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Frequency
0=One Time Payment
1=Annual Payment
12=Monthly Payment
2=Semi-Annual
24=Semi-Monthly Payment
26=BiWeekly Payment
4=Quarterly
Default Value: PA_RT_CAL_ACT_V.PYMT_FREQ
|
| 45 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 46 |
VALIDATION_RUN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Validation Run
Y/N Table Edit
Default Value: Y
|
| 47 |
PA_RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Run ID
Prompt Table:
%CALC_PROMPT
|
| 48 |
PA_PMT_END_DT |
Date(10) |
DATE |
Pay Period End Date
Default Value: PA_RT_CAL_ACT_V.PA_PMT_END_DT
|
| 49 |
PA_CHECK_DATE |
Date(10) |
DATE |
Check Date
Default Value: PA_RT_CAL_ACT_V.PA_CHECK_DATE
|
| 50 |
COLA_ADJ_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
COLA Percentage
|
| 51 |
CONFIRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Selection
C=Confirmation Processing
P=Preliminary Processing
Default Value: P
|
| 52 |
LIST_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Name of group of employees
Prompt Table:
PA_CLC_GRP_VW
|