PY_RESNRA_AET

(SQL Table)
Index Back

Mass Reset Consent

Application Engine State Record: Reset 1042-S Consent to Receive Electronic Year End Form.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REG_SELECT_PROC Character(1) VARCHAR2(1) NOT NULL Regular or Select Empl Proc
A=Select Tax Reporting Agencies
C=Selected W-2 Companies
E=Selected EMPLIDs
F=All Payees
G=Selected Payees
H=Within Selected Hire Dates
J=All Tax Agencies
L=Select Jurisdictions
M=Within Selected Companies
P=Within Selected Paygroups
R=All Employees
S=Selected Employees
T=Sel Elig Locals by State
5 PY_YE_CO_IND Character(1) VARCHAR2(1) NOT NULL Indicates COMPANY found.

Y/N Table Edit

Default Value: N

6 PY_YE_EE_IND Character(1) VARCHAR2(1) NOT NULL Indicates EMPLID found.

Y/N Table Edit

Default Value: N

7 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
8 GB_EFFDT Date(10) DATE Group As Of Date
9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
10 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename