RETROPAY_RQS_VW(SQL View) |
Index Back |
|---|---|
Retro Pay Request ViewRetro Pay Request View |
| select retropay_seq_no, emplid, EMPL_RCD, retropay_effdt, retropay_pgm_id, retropay_rqst_type, prcs_end_dt, mass_retro_rqst_id, retro_company, retro_paygroup, retro_pay_end_dt, retro_off_cycle, retro_page_no, retro_line_no, retropay_prcs_flag, duplicate_flag, proc_dttmstamp from PS_RETROPAY_RQST where retropay_prcs_flag in ('C', 'P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RETROPAY_SEQ_NO |
Character(8) | VARCHAR2(8) NOT NULL | Retro Pay Sequence Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DTA_VW |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: JOB |
| 4 | RETROPAY_EFFDT | Date(10) | DATE | Retro Pay Effective Date |
| 5 | RETROPAY_PGM_ID | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Program ID
Prompt Table: RETROPAYPGM_TBL |
| 6 | RETROPAY_RQST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Request Type
A=Additional Pay Request J=Job Related Request M=Mass Retro Pay Request |
| 7 | PRCS_END_DT | Date(10) | DATE | Process End Date |
| 8 | MASS_RETRO_RQST_ID | Character(5) | VARCHAR2(5) NOT NULL |
Mass Retro Request ID
Prompt Table: MASS_RETRO_RQST |
| 9 | RETRO_COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Company
Prompt Table: COMPANY_TBL |
| 10 | RETRO_PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Paygroup
Prompt Table: PAYGROUP_TBL |
| 11 | RETRO_PAY_END_DT | Date(10) | DATE | Retro Pay - Pay End Date |
| 12 | RETRO_OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Off Cycle
Y/N Table Edit Default Value: N |
| 13 | RETRO_PAGE_NO | Number(4,0) | SMALLINT NOT NULL | Retro Pay Page Number |
| 14 | RETRO_LINE_NO | Number(3,0) | SMALLINT NOT NULL | Retro Pay Line Number |
| 15 | RETROPAY_PRCS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Retro Pay Process Flag
C=Calculated N=Not Processed P=Loaded to Paysheets R=Recalculate Request X=Extracted Default Value: N |
| 16 | DUPLICATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Flag
Y/N Table Edit Default Value: N |
| 17 | PROC_DTTMSTAMP | DateTime(26) | TIMESTAMP | Process Date Timestamp |