RCN_FLD_EVNT_VW (SQL View)	Index Back
Recon alias prompt This record is used in Reconciliation to define the type of columns that will be used in the reconciliation.

RCN_FLD_EVNT_VW

(SQL View)

Recon alias prompt

This record is used in Reconciliation to define the type of columns that will be used in the reconciliation.

SELECT RECNAME, RCN_FIELD_ALIAS, FIELDNAME FROM PS_RCN_FIELD_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RCN_EVENT_TBL Character(15) VARCHAR2(15) NOT NULL Event Record for Reconciliation

2 RCN_FIELD_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation field/record alias name -- user or system defined

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RCN_EVENT_TBL	Character(15)	VARCHAR2(15) NOT NULL	Event Record for Reconciliation
2	RCN_FIELD_ALIAS	Character(30)	VARCHAR2(30) NOT NULL	Reconciliation field/record alias name -- user or system defined
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).