RETROPAY_SEQ_NOA=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
Default Value: N
RETROPAY_RQU_VW(SQL View) |
Index Back |
|---|---|
Retro Pay Request Undo ViewRetro Pay Request Undo View |
| SELECT a.retropay_seq_no , a.emplid , a.empl_rcd , b.name , a.retropay_prcs_flag FROM ps_retropay_rqst a , PS_PERSON_NAME b WHERE retropay_rqst_type <> 'M' AND retropay_prcs_flag NOT IN ('F','W','P','V','M') AND a.emplid = b.emplid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RETROPAY_SEQ_NO |
Character(15) | VARCHAR2(15) NOT NULL | Retro Pay Sequence Number |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | 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 Default Value: N |