BN_M_EBX_CODES (SQL Table)	Index Back
PeopleSoft Code translation This view is used for the eBenX integration with Peoplesoft Benefits. This view joins to BN_M_SNAP_FILTR which is only populated during the EBNX_EXTRACT Application Engine Process. This record is populated with Peoplesoft Codes (ie Country code), their translated values and, if required, their parent key

BN_M_EBX_CODES

(SQL Table)

PeopleSoft Code translation

This view is used for the eBenX integration with Peoplesoft Benefits. This view joins to BN_M_SNAP_FILTR which is only populated during the EBNX_EXTRACT Application Engine Process. This record is populated with Peoplesoft Codes (ie Country code), their translated values and, if required, their parent key

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

3 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key

4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	FIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Field Value
3	KEY1	Character(65)	VARCHAR2(65) NOT NULL	First Key
4	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr