TRN_EEPROV_COST

(SQL Table)
Index Back

EE Training Provider Cost

Use TRN_TUIT_REIMB to record cost information for students who have applied to your company for tuition reimbursement for training courses co

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 COURSE_START_DT Date(10) DATE Course Start Date
3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

Prompt Table: COURSE_TBL

4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

Prompt Table: CRSE_SESSN_TBL

5 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
6 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

Prompt Table: TRN_VENDOR_TBL

7 SESSION_SW Character(1) VARCHAR2(1) NOT NULL Coming from session table

Y/N Table Edit

Default Value: N

8 USER_UPDATE Character(1) VARCHAR2(1) NOT NULL User Update

Y/N Table Edit

Default Value: N

9 PER_EE_COST Number(19,3) DECIMAL(18,3) NOT NULL PER_EE_COST
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

13 FINANCED_COST_FRA Number(19,3) DECIMAL(18,3) NOT NULL Financed Cost
14 FINANCING_DEPT_FRA Character(10) VARCHAR2(10) NOT NULL Financing Department

Prompt Table: DEPT_TBL

15 FINANCING_FUND_FRA Character(6) VARCHAR2(6) NOT NULL Financing Fund

Prompt Table: TRN_VENDOR_TBL

16 CHARGEABLE_SW_FRA Character(1) VARCHAR2(1) NOT NULL Chargeable switch

Y/N Table Edit

Default Value: N

17 COMPANY_COST_FRA Number(19,3) DECIMAL(18,3) NOT NULL Company Cost
18 CHARGEABLE_CST_FRA Number(19,3) DECIMAL(18,3) NOT NULL Chargeable Cost
19 CERTIFIED_SW_FRA Character(1) VARCHAR2(1) NOT NULL Certified

Y/N Table Edit

Default Value: N

20 BILLED_FRA Character(1) VARCHAR2(1) NOT NULL Billed

Y/N Table Edit

Default Value: N

21 BILL_PROCESS_DT Date(10) DATE Date Entered
22 AGREEMENT_DT_FRA Date(10) DATE Agreement Date

Prompt Table: AGREEMNT_FRA_VW

23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: AGREEMT_FRA_VW1