OPRIDRUN_CNTL_IDPrompt Table: GP_PYENT_OPR_VW
C=Data Cartridge
D=Flexible Diskette
R=CD ROM
T=Magnetic Tape
Default Value: T
N=No
Y=Yes
Default Value: N
Prompt Table: GPGB_ACTECON_VW
Y/N Table Edit
Default Value: Y
GPGB_RNCTL_EOYR(SQL Table) |
Index Back |
|---|---|
GP UK EOYR Run controlRun control record for end of year returns application engine |
| # | 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 | GPGB_TAX_BGN_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT_OPR_VW |
| 5 | GPGB_EOYR_FILENAME | Character(6) | VARCHAR2(6) NOT NULL | End of year submissions filename |
| 6 | GPGB_EOYR_SUBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
End of Year Submissions - Submission method
C=Data Cartridge D=Flexible Diskette R=CD ROM T=Magnetic Tape Default Value: T |
| 7 | GPGB_EOYR_SUBTOT | Character(1) | VARCHAR2(1) NOT NULL |
End of Year Submissions - Subtotal by Paygroup option flag.
N=No Y=Yes Default Value: N |
| 8 | GPGB_ER_PERMIT_NUM | Character(12) | VARCHAR2(12) NOT NULL | Permit Number for end of year submissions on magnetic media. |
| 9 | GPGB_REQ_ECON | Character(9) | VARCHAR2(9) NOT NULL |
Employers Contracted Out Number
Prompt Table: GPGB_ACTECON_VW |
| 10 | GPGB_NO_ECON | Character(1) | VARCHAR2(1) NOT NULL |
Field used to include ees without ECON numbers in eoyr submissions
Y/N Table Edit Default Value: Y |