RTROUNDO_RUNCTL(SQL Table) |
Index Back |
---|---|
Retropay Undo RuncontrolRetropay Undo Runcontrol |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
3 | RETROPAY_SEQ_NO | Character(8) | VARCHAR2(8) NOT NULL |
Retro Pay Sequence Number
Prompt Table: RETROPAY_RQU_VW |
4 | PROCESS_MASS | Character(1) | VARCHAR2(1) NOT NULL |
Process Mass Retro ?
Y/N Table Edit Default Value: N |
5 | MASS_ALL | Character(1) | VARCHAR2(1) NOT NULL |
All?
Y/N Table Edit Default Value: N |
6 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: MASS_RETRO_RQST |
7 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table: PAY_RUN_TBL |
8 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
9 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
10 | PAY_END_DT | Date(10) | DATE |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
11 | UNDO_TO_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Undo To Process
C=Calculated D=Delete N=Not Processed Default Value: C |
12 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |