GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_PRD_IDPrompt Table: GP_CAL_PRD1_VW
OFF_CYCLE_IDA=Calculation Successful
C=Cancelled
E=Calculated with Errors
F=Processing finalized
I=Process initiated
U=Unprocessed
Default Value: U
Default Value: %Date
GP_OFFCYCLE(SQL Table) |
Index Back |
|---|---|
Off Cycle SetUp (parent)identifies an off cycle group and contains data that applies to all payees and payments within this group. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 2 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GP_CAL_PRD1_VW |
| 3 | OFF_CYCLE_ID |
Character(18) | VARCHAR2(18) NOT NULL | Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments |
| 4 | GP_RUN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Processing Status; initial use to reflect the status of an Off-cycle group as to whether processing has been initiated or finalized
A=Calculation Successful C=Cancelled E=Calculated with Errors F=Processing finalized I=Process initiated U=Unprocessed Default Value: U |
| 5 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 6 | PYMT_DT | Date(10) | DATE |
Payment Date
Default Value: %Date |