GP_OC_SETUP (SQL Table)	Index Back
OffCycle Configuration by Type Configuration for Off cycle interface. Parent record

GP_OC_SETUP

(SQL Table)

OffCycle Configuration by Type

Configuration for Off cycle interface. Parent record

Parent Record Of GP_NRP_OCS_C_AD GP_NRP_OCS_M_AD GP_NRP_OCS_U_AD GP_OC_SETUP_A GP_OC_SETUP_C GP_OC_SETUP_M GP_OC_SETUP_U

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY_VW

2 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

3 ALLW_OC_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether a given off cycle type is allowed for a given country {y/n}
Y/N Table Edit
Default Value: Y

4 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_EDIT_FLD1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY_VW
2	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
3	ALLW_OC_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether a given off cycle type is allowed for a given country {y/n} Y/N Table Edit Default Value: Y
4	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_EDIT_FLD1