OPRIDPrompt Table: GPFR_ONPAY_D_VW
Y/N Table Edit
Default Value: N
N=Employee Negative Amounts
P=Employee Positive Amounts
Prompt Table: GPFR_ONPAY_GRP
GPFR_ONPAY_SAVE(SQL Table) |
Index Back |
|---|---|
Selection Criteria storagePayroll results : storage of the Selection Criteria per OPRID. |
| # | 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 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GPFR_ONPAY_D_VW |
| 3 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 4 | GPFR_ONPAY_PI | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Positive Inputs Only
Y/N Table Edit Default Value: N |
| 5 | GPFR_ONPAY_SAMT | Character(1) | VARCHAR2(1) NOT NULL |
GPFR: Selection on Amount
N=Employee Negative Amounts P=Employee Positive Amounts |
| 6 | GPFR_ONPAY_GRP | Character(3) | VARCHAR2(3) NOT NULL |
GPFR: Element List
Prompt Table: GPFR_ONPAY_GRP |