GPFR_BANKCAL2_S (SQL View)	Index Back
Used as Prompt Table EFT_RUN Used as Prompt Table in record GPFR_EFT_RNCTL. Dedicated to retrieve and display CAL_RUN_ID.

GPFR_BANKCAL2_S

(SQL View)

Used as Prompt Table EFT_RUN

Used as Prompt Table in record GPFR_EFT_RNCTL. Dedicated to retrieve and display CAL_RUN_ID.

SELECT DISTINCT PRC.CAL_RUN_ID , OPR.OPRID FROM PS_GPFR_PAYMENT A %Sql(GPFR_SECU_IDNTCALRUN_SQL,A) AND A.PAYMENT_MTHD = 'T' AND A.PMT_STATUS = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).