PY_RESNRA_AET(SQL Table) |
Index Back |
---|---|
Mass Reset ConsentApplication 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 |