RETRODED_SEQ_NOEMPLIDPrompt Table: RETRODED_RQS_VW
Prompt Table: RETRODEDMAS_TBL
C=Calculated
I=Invalidated
N=Not Processed
P=Loaded to Paysheet
R=Rejected
X=Extracted
RETRODED_DEL_VW(SQL View) |
Index Back |
|---|---|
RetroDed by Emplid VW |
| SELECT RETRODED_SEQ_NO , EMPLID , EMPL_RCD , RETRODED_EFFDT , MASS_RETRO_RQST_ID , RETRODED_PRCS_FLAG FROM PS_RETRODED_RQST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RETRODED_SEQ_NO |
Character(8) | VARCHAR2(8) NOT NULL | Retro Ded Sequence Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RETRODED_RQS_VW |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | RETRODED_EFFDT | Date(10) | DATE | Retro Ded Effective Date |
| 5 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: RETRODEDMAS_TBL |
| 6 | RETRODED_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Retro Ded Process Flag
C=Calculated I=Invalidated N=Not Processed P=Loaded to Paysheet R=Rejected X=Extracted |