EMPLIDPrompt Table: PERSONAL_DTA_VW
A=Action Required
C=Calculated
F=Confirmed Payment
M=Manually Loaded to Paysheet
N=Not Processed
P=Loaded to Paysheets
R=Recalculate Request
S=Suspended
V=Paycheck Reversed
W=Cancelled / Withdrawn
X=Extracted
RETRO_RQST1_VW(SQL View) |
Index Back |
|---|---|
Retro Pay Rqst Vw 1-Job/AddlPyRetro Pay Rqst Vw 1-Job/AddlPy |
| SELECT a.emplid , b.name , a.retropay_prcs_flag FROM ps_retropay_rqst a , PS_PERSON_NAME b WHERE a.retropay_rqst_type <> 'M' AND a.retropay_prcs_flag IN ( 'N','R') AND a.emplid = b.emplid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DTA_VW |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | RETROPAY_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added/modified for RETROPAY_PRCS_FLAG field, same changes must be done for RETROPAY_PRCS_FLG1 field.
A=Action Required C=Calculated F=Confirmed Payment M=Manually Loaded to Paysheet N=Not Processed P=Loaded to Paysheets R=Recalculate Request S=Suspended V=Paycheck Reversed W=Cancelled / Withdrawn X=Extracted |