GP_OFFCYCL_U_VW (SQL View)	Index Back
Off Cycle Unscheduled Record identifies a single EE (RCD) and Calendar combination to be processed in an Off-Cycle process. Contains field to override calendar attributes that affect the processing of the offcycle "payment". This view is for the subset of Off-Cycles that are Unscheduled Payments

GP_OFFCYCL_U_VW

(SQL View)

Off Cycle Unscheduled

Record identifies a single EE (RCD) and Calendar combination to be processed in an Off-Cycle process. Contains field to override calendar attributes that affect the processing of the offcycle "payment". This view is for the subset of Off-Cycles that are Unscheduled Payments

SELECT GP_PAYGROUP , CAL_PRD_ID , OFF_CYCLE_ID , SEQNO , GP_TX_REASON , EMPLID , EMPL_RCD , CAL_ID , SEQ_NUM5 , GP_TX_TYPE , GP_CORR_TYPE , CAL_RUN_ID , SRC_CAL_ID , SRC_CAL_RUN_ID , PYMT_DT , PRD_BGN_DT , PRD_END_DT , CALC_FROM_DT , CALC_THRU_DT , RUN_TYPE , PYMT_KEY1 , PYMT_KEY2 , PYMT_KEY3 , PYMT_KEY4 , GP_NO_REG_RES_IND , PIN_ELEM_GRP_NUM , PAYMENT_MTHD , PYMT_ID , PYMT_NBR , PIN_GROSS_VAL , PIN_NET_VAL , ISSUE_DT , PYMT_VALIDATE_IND FROM PS_GP_PYE_CAL WHERE GP_TX_TYPE = 'U'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

2 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

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 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

5 GP_TX_REASON Character(18) VARCHAR2(18) NOT NULL Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information
Prompt Table: GP_OC_SETUP_U

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GP_PG_PERS_SRCH

7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: GP_PGRP_JOB_VW

8 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

9 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number

10 GP_TX_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance. XLAT values are assigned to support batch processing order
A=Advance
M=Manual Payment
R=Correction
U=Additional Payment
Default Value: U

11 GP_CORR_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies type of correction requested (in offcycle). See Translate values for set of types
N=Normal retro
R=Replacement
V=Reversal - Normal retro
W=Reversal - Replacement
Y=Year end adjustment

12 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

13 SRC_CAL_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar ID

14 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID

15 PYMT_DT Date(10) DATE NOT NULL Payment Date
Default Value: GP_OFFCYCLE_D.PYMT_DT

16 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date

17 PRD_END_DT Date(10) DATE NOT NULL Pay Period End Date

18 CALC_FROM_DT Date(10) DATE Calculate From Date. Used to aid in calculating only a partial pay period

19 CALC_THRU_DT Date(10) DATE Calculate Thru Date

20 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
Prompt Table: GP_RUN_TYPEP_VW

21 PYMT_KEY1 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
Prompt Table: %EDITTABLE11

22 PYMT_KEY2 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
Prompt Table: %EDITTABLE12

23 PYMT_KEY3 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
Prompt Table: %EDITTABLE13

24 PYMT_KEY4 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
Prompt Table: %EDITTABLE14

25 GP_NO_REG_RES_IND Character(1) VARCHAR2(1) NOT NULL Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle
Y/N Table Edit
Default Value: N

26 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group
Prompt Table: GP_PIN_EG1_VW

27 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
Default Value: U
Prompt Table: GP_X_PMTMTHD_VW

28 PYMT_ID Character(6) VARCHAR2(6) NOT NULL Payment Identification

29 PYMT_NBR Number(18,0) DECIMAL(18) NOT NULL Payment Number

30 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

31 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value

32 ISSUE_DT Date(10) DATE Issue Date for Payment Reconciliation

33 PYMT_VALIDATE_IND Character(1) VARCHAR2(1) NOT NULL This field indicates the Manual Payment validation status.
C=Validate at Calculation Time
N=Not Validated
V=Validated

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
2	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
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	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	GP_TX_REASON	Character(18)	VARCHAR2(18) NOT NULL	Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information Prompt Table: GP_OC_SETUP_U
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GP_PG_PERS_SRCH
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: GP_PGRP_JOB_VW
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number
10	GP_TX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance. XLAT values are assigned to support batch processing order A=Advance M=Manual Payment R=Correction U=Additional Payment Default Value: U
11	GP_CORR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies type of correction requested (in offcycle). See Translate values for set of types N=Normal retro R=Replacement V=Reversal - Normal retro W=Reversal - Replacement Y=Year end adjustment
12	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
13	SRC_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	Source Calendar ID
14	SRC_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Source Calendar Run ID
15	PYMT_DT	Date(10)	DATE NOT NULL	Payment Date Default Value: GP_OFFCYCLE_D.PYMT_DT
16	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
17	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date
18	CALC_FROM_DT	Date(10)	DATE	Calculate From Date. Used to aid in calculating only a partial pay period
19	CALC_THRU_DT	Date(10)	DATE	Calculate Thru Date
20	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name Prompt Table: GP_RUN_TYPEP_VW
21	PYMT_KEY1	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number Prompt Table: %EDITTABLE11
22	PYMT_KEY2	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number Prompt Table: %EDITTABLE12
23	PYMT_KEY3	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number Prompt Table: %EDITTABLE13
24	PYMT_KEY4	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number Prompt Table: %EDITTABLE14
25	GP_NO_REG_RES_IND	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate that no element resolution is to take place except the processing of retro adjustment and PI. Introduced with Offcycle Y/N Table Edit Default Value: N
26	PIN_ELEM_GRP_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number for Element Group Prompt Table: GP_PIN_EG1_VW
27	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer Default Value: U Prompt Table: GP_X_PMTMTHD_VW
28	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
29	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
30	PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
31	PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
32	ISSUE_DT	Date(10)	DATE	Issue Date for Payment Reconciliation
33	PYMT_VALIDATE_IND	Character(1)	VARCHAR2(1) NOT NULL	This field indicates the Manual Payment validation status. C=Validate at Calculation Time N=Not Validated V=Validated