| # |
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 |
RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table:
PAY_RUN_TBL
|
| 4 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 5 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 6 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 7 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
Default Value: INSTALLATION.BAL_ID_FOR_CAL_YR
|
| 8 |
BALANCE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Balances for Year
Prompt Table:
BAL_YR_NO_CO_VW
|
| 9 |
BALANCE_QTR |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Quarter
Prompt Table:
BALQTR_NO_CO_V
|
| 10 |
BALANCE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Balances for Period
Prompt Table:
BALPRD_NO_CO_VW
|
| 11 |
MIN_OT_HRS |
Number(3,0) |
SMALLINT NOT NULL |
Minimum Overtime Hours
|
| 12 |
VARIATION_REASON |
Character(80) |
VARCHAR2(80) NOT NULL |
Reasons for Variation
|
| 13 |
ROE_FINAL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
ROE Final Print
Y/N Table Edit
Default Value: N
|
| 14 |
ROE_NO_START |
Number(8,0) |
INTEGER NOT NULL |
ROE Start Number
|
| 15 |
REPORTING_MEDIUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Medium
C=Cartridge
D=Diskette
T=Tape
X=Electronic
|
| 16 |
WHICH_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Which Date to use
A=Use Adjustment Date
B=Use Balance Date
Default Value: B
|
| 17 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 18 |
CRFN_NBR |
Character(6) |
VARCHAR2(6) NOT NULL |
CRFN Number
|
| 19 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 20 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 21 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
Prompt Table:
PAY_CALENDAR
|
| 22 |
CSB_SERIES_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
CSB Series Code
Prompt Table:
CSB_SERIES_TBL
|
| 23 |
ROE_FORM_LANG |
Character(1) |
VARCHAR2(1) NOT NULL |
ROE Form Language
E=English Language ROE Forms
F=French Language ROE Forms
Default Value: E
|
| 24 |
EE_CNT_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Employee Count State
CT=CONNECTICUT
ME=MAINE
NJ=NEW JERSEY
OR=OREGON
VT=VERMONT
Default Value: CT
|
| 25 |
REPORT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Option
D=Detail Report
F=Full report ?
R=Run ID Report ?
S=Summary Report
Default Value: S
|
| 26 |
W4_UPD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upd. Web, Single/All Employee
A=All Employees
S=Single Employee
W=Web created/Updated Employees
Default Value: A
|
| 27 |
RPT_EXMPT_ALLOWANC |
Character(1) |
VARCHAR2(1) NOT NULL |
Rep Employee Exmpt/Alwnce/Both
A=All
B=Exempt/ >10 Allowances
E=Claim Exempt
T=More Than Ten Allowances
Default Value: B
|
| 28 |
ORDER_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Option (Employeeid/Name)
I=Employee ID
N=Employee Name
Default Value: I
|
| 29 |
TERM_PROC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Check Processing Status
C=Paysheet Created
N=Not Processed
P=Loaded to Paysheets
X=Extracted
|
| 30 |
TERM_PGM_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Final Check Program ID
Prompt Table:
TERM_PGM_TBL
|
| 31 |
CUR_TERM_PGM_EFFDT |
Date(10) |
DATE |
Effective Date
Prompt Table:
TERM_CLONE_VW
|
| 32 |
NEW_TERM_PGM_EFFDT |
Date(10) |
DATE |
New Effective Date
Default Value: %date
|
| 33 |
NEW_TERM_PGM_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
New Final Check Program ID
|
| 34 |
CLONE_EARNS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clone Earnings Definition
Y/N Table Edit
Default Value: N
|
| 35 |
CLONE_LVE_ACCR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clone Leave Accr Definition
Y/N Table Edit
Default Value: N
|
| 36 |
CLONE_DED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clone Deductions Definition
Y/N Table Edit
Default Value: N
|
| 37 |
ALIGN_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Alignment Count
|
| 38 |
CPS_REF_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference ID
|
| 39 |
TAX_YEAR |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Tax Year
|
| 40 |
TAX_QTR |
Number(3,0) |
SMALLINT NOT NULL |
Tax quarter
|
| 41 |
TAX_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Tax Month
|
| 42 |
ROE_STAT_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
ROE Process
A=All
C=Complete
D=Delete
F=XML Failed
G=Generate
H=Hold
R=XML Rejected
X=XML Generated
Default Value: H
|
| 43 |
ROE_DELETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete ROEs
Y/N Table Edit
Default Value: N
|
| 44 |
ROE_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
ROE Sort By
1=Employee Name
2=Employee ID
Default Value: 1
|
| 45 |
ELECTRONIC_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Processing
Y/N Table Edit
Default Value: N
|
| 46 |
TRANS_CNTL_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transmitter control code.
|
| 47 |
MEDIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Media
D=Diskette
N=None
R=Report
T=Tape
|
| 48 |
DISKETTE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Diskette Type
0=Not Applicable
1=3.5 Inches High Density
2=3.5 Inches Double Density
|
| 49 |
ROE_PROC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ROE Process Type
C=Correct Rejected/Failed Data
S=Submit Generated ROE Data
Default Value: S
|
| 50 |
ROE_IMPORT_FILE |
Character(80) |
VARCHAR2(80) NOT NULL |
ROE Import File Name
|
| 51 |
ROE_EXPORT_FILE |
Character(80) |
VARCHAR2(80) NOT NULL |
ROE Export File Name
|
| 52 |
BAL_1042 |
Character(1) |
VARCHAR2(1) NOT NULL |
PATCH 17185082 - MODIFY TAX015.SQR TO AUDIT PS_TAX1042_BALANCE VS PAY_TAX_1042 DATA
Y/N Table Edit
Default Value: N
|
| 53 |
WC_RUN_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
WorkCenter Run Option for Audit reports.
D=Delete Data Only
R=Refresh Data
Default Value: R
|
| 54 |
ROE_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number of ROE for each Payroll Extract file to submit.
|