CRSE_SESS_INSTR (SQL Table)	Index Back
Training Course Instructors CRSE_SESS_INSTR is one of a group of records used to record data about specific sessions of a training course for the Training Administration application. Use CRSE_SESS_INSTR to identify instructors of a specific course session.

CRSE_SESS_INSTR

(SQL Table)

Training Course Instructors

CRSE_SESS_INSTR is one of a group of records used to record data about specific sessions of a training course for the Training Administration application. Use CRSE_SESS_INSTR to identify instructors of a specific course session.

Parent record: CRSE_SESS_DATES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
Prompt Table: COURSE_TBL

2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
Prompt Table: CRSE_SESS_DATES

3 CUT_SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Cut Session Nbr
Default Value: 1

4 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

5 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID
Prompt Table: TRN_VENDOR_TBL

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

7 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

9 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
Default Value: CRSE_SESS_DATES.DURATION_TIME

10 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit
Default Value: H
Prompt Table: TD_COST_UNIT_VW

11 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration
Default Value: CRSE_SESS_DATES.DURATION_CONVERTED

12 DURATION_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit
Default Value: CRSE_SESS_DATES.DURATION_UNIT_CD
Prompt Table: DT_COST_UNIT_VW

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

15 TRN_SYS_UPDATED Character(1) VARCHAR2(1) NOT NULL French Report 2483 : System Maintained
Y/N Table Edit
Default Value: N

16 FINANCED_COST_FRA Number(19,3) DECIMAL(18,3) NOT NULL Financed Cost

17 FINANCING_DEPT_FRA Character(10) VARCHAR2(10) NOT NULL Financing Department
Prompt Table: DEPT_TBL

18 FINANCING_FUND_FRA Character(6) VARCHAR2(6) NOT NULL Financing Fund
Prompt Table: TRN_VENDOR_TBL

19 CHARGEABLE_SW_FRA Character(1) VARCHAR2(1) NOT NULL Chargeable switch
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Prompt Table: COURSE_TBL
2	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr Prompt Table: CRSE_SESS_DATES
3	CUT_SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Cut Session Nbr Default Value: 1
4	INSTRUCTOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Instructor ID
5	VENDOR	Character(6)	VARCHAR2(6) NOT NULL	Vendor ID Prompt Table: TRN_VENDOR_TBL
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	PER_UNIT_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Per Unit Cost
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
9	DURATION_TIME	Number(6,1)	DECIMAL(5,1) NOT NULL	Duration Time Default Value: CRSE_SESS_DATES.DURATION_TIME
10	COST_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Cost Unit Default Value: H Prompt Table: TD_COST_UNIT_VW
11	DURATION_CONVERTED	Number(6,1)	DECIMAL(5,1) NOT NULL	Converted Duration Default Value: CRSE_SESS_DATES.DURATION_CONVERTED
12	DURATION_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Duration Unit Default Value: CRSE_SESS_DATES.DURATION_UNIT_CD Prompt Table: DT_COST_UNIT_VW
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
14	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
15	TRN_SYS_UPDATED	Character(1)	VARCHAR2(1) NOT NULL	French Report 2483 : System Maintained Y/N Table Edit Default Value: N
16	FINANCED_COST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Financed Cost
17	FINANCING_DEPT_FRA	Character(10)	VARCHAR2(10) NOT NULL	Financing Department Prompt Table: DEPT_TBL
18	FINANCING_FUND_FRA	Character(6)	VARCHAR2(6) NOT NULL	Financing Fund Prompt Table: TRN_VENDOR_TBL
19	CHARGEABLE_SW_FRA	Character(1)	VARCHAR2(1) NOT NULL	Chargeable switch Y/N Table Edit Default Value: N