TRN_STDCOST_MAP (SQL Table)	Index Back
Student Cost mapping table This table is used to map ELM IDs with HR IDs.

TRN_STDCOST_MAP

(SQL Table)

Student Cost mapping table

This table is used to map ELM IDs with HR IDs.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRN_SRC_ID Character(19) VARCHAR2(19) NOT NULL ID used in the source system

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 TRN_LOCAL_ID Number(15,0) DECIMAL(15) NOT NULL map ELM ID w/ HR ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRN_SRC_ID	Character(19)	VARCHAR2(19) NOT NULL	ID used in the source system
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	TRN_LOCAL_ID	Number(15,0)	DECIMAL(15) NOT NULL	map ELM ID w/ HR ID