| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID
|
| 3 |
REPORT_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Form
A=T4A Slip
R=RL-1
T=T4 Slip
V=RL-2
X=All
|
| 4 |
SORT_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Indicator
D=Department Code
L=Location Code
N=Last Name
|
| 5 |
REPORTING_MEDIUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Medium
C=Cartridge
D=Diskette
T=Tape
X=Electronic
Default Value: T
|
| 6 |
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
Default Value: 0
|
| 7 |
RV1_PRIMARY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-1 Primary Sort
1=Standard Govt Sort Sequence
2=Quebec ID Number
3=Company
Default Value: 3
|
| 8 |
T4_PRIMARY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Primary Sort Sequence
1=Standard Govt Sort Sequence
2=Payroll Account Number
3=Company
Default Value: 3
|
| 9 |
T4_SEC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Secondary Sort
1=Location Code
2=Department Code
3=Mail Drop
4=Postal Code
5=None of the above
|
| 10 |
T4_THIRD_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Third Sort
1=Employee Name
2=Employee ID
3=Employee SIN
|
| 11 |
RV1_SEC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-1 Secondary Sort
1=Location Code
2=Department Code
3=Mail Drop
4=Postal Code
5=None of the above
|
| 12 |
RV2_PRIMARY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-2 Primary Sort
1=Standard Gov't Sort Sequence
2=Quebec ID Number
3=Company
Default Value: 3
|
| 13 |
RV2_SEC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-2 Secondary Sort
1=Location Code
2=Department Code
3=Mail Drop
4=Postal Code
5=None of the above
|
| 14 |
RV2_THIRD_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-2 Third Sort
1=Employee Name
2=Employee ID
3=Employee SIN
|
| 15 |
RV1_THIRD_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-1 Third Sort
1=Employee Name
2=Employee ID
3=Employee SIN
|
| 16 |
T4A_PRIMARY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Primary Sort
1=Standard Gov't Sort Sequence
2=Payroll Account Number
3=Company
Default Value: 3
|
| 17 |
T4A_SEC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Second Sort
1=Location Code
2=Department Code
3=Mail Drop
4=Postal Code
5=None of the above
|
| 18 |
T4A_THIRD_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Third Sort
1=Employee Name
2=Employee ID
3=Employee SIN
|
| 19 |
SUPP_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplementary Form Type
1=Canadian Government
2=Other
Default Value: 1
|
| 20 |
PRIMARY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Sort
1=Payroll Account Number
2=Company
|
| 21 |
SECONDARY_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Sort
1=Location Code
2=Department Code
3=Mail Drop
4=Postal Code
5=None
|
| 22 |
THIRD_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Third Sort
1=Employee Name
2=Empl ID
3=Empl SIN
|
| 23 |
SUMMARY_OR_SGMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary or Segment Data
S=Summary Data Only
X=Summary and Segment Data
Default Value: S
|
| 24 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 25 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 26 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 27 |
OPEN_CLOSE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Close Flag
C=Close
O=Open
Default Value: O
|
| 28 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 29 |
PERCENT_TD1_CHANGE |
Signed Number(8,4) |
DECIMAL(6,4) NOT NULL |
Percent TD1 Change
|
| 30 |
AMOUNT_TD1_CHANGE |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Amount TD1 Change
|
| 31 |
RESET_LETTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Special Letters
Y/N Table Edit
Default Value: Y
|
| 32 |
PCT_TD1_CHANGE_QC |
Signed Number(8,4) |
DECIMAL(6,4) NOT NULL |
Percent TD1 Change (Quebec)
|
| 33 |
AMT_TD1_CHANGE_QC |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Amount TD1 Change (Quebec)
|
| 34 |
RESET_LETTER_QC |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Special Letters (Quebec)
Y/N Table Edit
Default Value: Y
|
| 35 |
RESET_CPP_MONTHS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset CPP Subject Months
Y/N Table Edit
Default Value: N
|
| 36 |
INQUIRY_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Pre Load Edit Inquiry Month
|
| 37 |
INQUIRY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Load Inquiry Type
M=Month Totals Only
T=YTD Totals Only
Y=YTD Totals to Inquiry Month
|
| 38 |
PENS_ADJ_CAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Pension Adjustment Calendar Yr
|
| 39 |
PENS_ADJ_PAY_PDS |
Number(2,0) |
SMALLINT NOT NULL |
Pension Adj Pay Periods
|
| 40 |
T4A_SUMM_OR_SGMT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Summary or Segment Ind
S=Summary
Default Value: S
|
| 41 |
T4_SUMM_OR_SGMT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Summary or Segment Ind
S=Summary
X=Summary and Segment
Default Value: S
|
| 42 |
AUDIT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Year End Audit Indicator
A=T4A
R=RL-1
T=T4
V=RL-2
X=All
|
| 43 |
AUDIT_SORT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Year End Audit Sort Indicator
D=Department
L=Location
N=Last Name
P=Province
|
| 44 |
RESET_UI_YEARLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset EI Yearly Maximum
Y/N Table Edit
Default Value: N
|
| 45 |
RESET_TO_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset EI Yearly Value
A=Reset EI Yearly Max To Zero
B=Reset EI Yearly to Tbl Max
|
| 46 |
T4_FORM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Form Type
L=Laser
X=XML Publisher
Default Value: X
|
| 47 |
T4_COPY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Copy Type
1=Government Copy
2=Employee Copy
4=Company Copy
|
| 48 |
T4A_FORM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Form type
L=Laser
X=XML Publisher
|
| 49 |
T4A_COPY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Copy Type
1=Government Copy
2=Employee Copy
4=Company Copy
|
| 50 |
RV1_FORM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-1 Form Type
L=Laser
|
| 51 |
RV2_FORM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-2 Form Type
L=Laser
|
| 52 |
RESET_TD1X |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Federal Commission
Y/N Table Edit
Default Value: Y
|
| 53 |
RESET_MR19CV |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Quebec Commission
Y/N Table Edit
Default Value: Y
|
| 54 |
EMPL_DETAIL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Employee Detail
Y/N Table Edit
Default Value: Y
|
| 55 |
T4_PROCESSING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Processing Type
A=Print All Amended
C=Print All Cancelled
E=Reprint Amend/Cancel/Reissue
N=Print All Reissued
R=Print All Originals
S=Reprint Selected Original(s)
Default Value: R
|
| 56 |
T4A_PROCESSING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Processing Type
A=Print All Amended
C=Print All Cancelled
E=Reprint Amend/Cancel/Reissue
N=Print All Reissued
R=Print All Originals
S=Reprint Selected Original(s)
Default Value: R
|
| 57 |
RL1_PROCESSING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
RL1 Processing Type
A=Print All Amended
C=Print All Cancelled
E=Reprint Amended/Cancelled
R=Print All Originals
S=Reprint Selected Original(s)
Default Value: R
|
| 58 |
RL2_PROCESSING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
RL2 Processing Type
A=Print All Amended
C=Print All Cancelled
E=Reprint Amended/Cancelled
R=Print All Originals
S=Reprint Selected Original(s)
Default Value: R
|
| 59 |
RESET_CROSS_PROV |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Cross Province
Y/N Table Edit
Default Value: Y
|
| 60 |
RESET_QUE_HEALTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Quebec Health
Y/N Table Edit
Default Value: Y
|
| 61 |
SELECT_RELOAD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Option
A=Load All Employees
E=Load Selected Employee(s)
G=Load Selected Group(s)
Default Value: A
|
| 62 |
RL1_FILE_PROC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
RL1 Mag Media Processing Type
A=Amended Slips
C=Cancelled Slips
O=Original Slips
Default Value: O
|
| 63 |
RL2_FILE_PROC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
RL2 Mag Media Processing Type
A=Amended Slips
C=Cancelled Slips
O=Original Slips
Default Value: O
|
| 64 |
T4_FINAL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4 Final Print
Y/N Table Edit
Default Value: N
|
| 65 |
T4A_FINAL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
T4A Final Print
Y/N Table Edit
Default Value: N
|
| 66 |
RL1_FINAL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-1 Final Print
Y/N Table Edit
Default Value: N
|
| 67 |
RL2_FINAL_PRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
RL-2 Final Print
Y/N Table Edit
Default Value: N
|
| 68 |
SLIP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by T4/T4A Magnetic Media SQR (CTX910XM) to determine tax form slip to be processed.
A=T4A Slips Only
T=T4 Slips Only
X=T4 and T4A Slips
Default Value: X
|
| 69 |
PY_RPT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by T4/T4A Magnetic Media SQR (CTX910XM) to deterrmine the type of slips to be processed.
A=Amended Slips
N=Reissued Slips
O=Original Slips
Default Value: O
|
| 70 |
CPP_QPP_NLGRS_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
CPP/QPP Taxable Gross Edits
Y/N Table Edit
Default Value: N
|
| 71 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
|
| 72 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 73 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 74 |
CONSENT_PROC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consent Report Request Flag
A=All Statuses Summary
C=Consented
R=Reset
W=Withdrawn
Default Value: A
|