| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 2 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 4 |
CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
|
| 5 |
PRDIC_RUNSTAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Periodic Run Status
C=Complete with no Errors
E=Complete with Errors
I=Incomplete - Severe Errors
N=Not Run Yet
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 7 |
GROUP_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Group Name
|
| 8 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 9 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 10 |
PERIODIC_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Periodic Cycle
A=Annual Cycle
M=Monthly Cycle
Q=Quarterly Cycle
|
| 11 |
CALC_ALL_PLANS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate All Plans
Y/N Table Edit
Default Value: N
|
| 12 |
ACCT_BAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Account Balances
Y/N Table Edit
Default Value: N
|
| 13 |
CASH_BAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Balances
Y/N Table Edit
Default Value: N
|
| 14 |
SERVICE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Service
Y/N Table Edit
Default Value: N
|
| 15 |
PARTIC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Participation
Y/N Table Edit
Default Value: N
|
| 16 |
PAYROLL_HIST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll History
Y/N Table Edit
Default Value: N
|
| 17 |
EXT_EMP_DATA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
External Employee Data
Y/N Table Edit
Default Value: N
|
| 18 |
CONS_HRS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Hours
Y/N Table Edit
Default Value: N
|
| 19 |
CONS_EARN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Earnings
Y/N Table Edit
Default Value: N
|
| 20 |
CONS_CONTRIB_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Contributions
Y/N Table Edit
Default Value: N
|
| 21 |
PENSION_ST_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Status Indicator
Y/N Table Edit
Default Value: N
|
| 22 |
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
|