OPRIDRUN_CNTL_ID10=Production
20=Test
GPAU_RC_TFN001(SQL Table) |
Index Back |
|---|---|
Run Cntl Record - TFN001AUSimilar to the table GPAU_RC_REPORTS, this table will be used to record the parameters that will be used to run SQR programs. This table is specific to TFN001AU.SQR. It will record the list of pay entities that will be included in the processing. |
| # | 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 | GPAU_RUN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Run Type for EOY Magnetic Type
10=Production 20=Test |
| 4 | GPAU_TFN_START_DT | Date(10) | DATE NOT NULL | TFN Report Start Date |
| 5 | GPAU_TFN_END_DT | Date(10) | DATE NOT NULL | TFN Report End Date |