GP_RTO_CRD_WRK(SQL Table) |
Index Back |
|---|---|
Rto Calendar in Run (wrk)Work record used in IDNT5 for lining up data normally found in CAL RUN DTL (on cycle) to also accomodate off cycle advances (for which the CAL RUN DTL info is not present or not correct) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | STRM_NUM | Number(4,0) | SMALLINT NOT NULL | Stream Number |
| 3 | SRC_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP1_VW |
| 5 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: %GP_EDIT_FLD1 |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 8 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 9 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 10 | PYMT_DT | Date(10) | DATE | Payment Date |
| 11 | SEL_CRIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Selection Criteria Option
0=Payee List 1=All Active 2=Active with PI 3=Active with Retro Trigger 4=Active with PI or Rto Trigger 5=Active or has PI 6=Active or has Retro Trigger 7=Active or has PI or Rto Trgr 8=All payees with PI 9=All payees with Retro Changes A=All with PI or Retro Trigger |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 13 | CAL_FINAL_TS | DateTime(26) | TIMESTAMP | Calendar Finalized Timestamp |