TRAINING013_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	ASOFDATE	Date(10)	DATE	As of Date
6	EFFDT	Date(10)	DATE	Effective Date
7	THRU_DATE	Date(10)	DATE	Thru Date
8	BUDGET_PERIOD	Character(10)	VARCHAR2(10) NOT NULL	Budget Period
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	ATTENDANCE_IN	Character(23)	VARCHAR2(23) NOT NULL	Attendance In
11	ATTENDANCE	Character(1)	VARCHAR2(1) NOT NULL	Enrollment/Attendance A=Currently Attending C=Completed D=Dropped E=Enrolled I=Incomplete L=Cancelled N=No Show O=Training Request Approved P=Need for Career Plan R=Request S=Session Waitlist T=Need for Training Program U=Training Request Authorized W=Course Waitlist X=Cancel Request for Training
12	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code
13	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr
14	OVERRIDE_COST	Character(1)	VARCHAR2(1) NOT NULL	Override Student Cost
15	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
16	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
17	COURSE_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Course Title
18	COURSE_START_DT	Date(10)	DATE	Course Start Date
19	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
20	FACILITY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Facility Name
21	VENDOR	Character(6)	VARCHAR2(6) NOT NULL	Vendor ID
22	COMPUTED_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Variable Cost
23	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	COST_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Cost Unit
25	PER_UNIT_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Per Unit Cost
26	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
27	DURATION_CONVERTED	Number(6,1)	DECIMAL(5,1) NOT NULL	Converted Duration
28	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
29	COMPUTED_DURATION	Number(6,1)	DECIMAL(5,1) NOT NULL	Converted Duration
30	DURATION_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Duration Unit
31	DURATION_TIME	Number(6,1)	DECIMAL(5,1) NOT NULL	Duration Time
32	FINANCED_COST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Financed Cost
33	FINANCING_DEPT_FRA	Character(10)	VARCHAR2(10) NOT NULL	Financing Department
34	FINANCING_FUND_FRA	Character(6)	VARCHAR2(6) NOT NULL	Financing Fund
35	USER_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	User Update
36	CERTIFIED_SW_FRA	Character(1)	VARCHAR2(1) NOT NULL	Certified
37	CHARGEABLE_SW_FRA	Character(1)	VARCHAR2(1) NOT NULL	Chargeable switch
38	BILLED_FRA	Character(1)	VARCHAR2(1) NOT NULL	Billed
39	BILL_PROCESS_DT	Date(10)	DATE	Date Entered
40	AGREEMENT_DT_FRA	Date(10)	DATE	Agreement Date
41	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
42	INSTRUCTOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Instructor ID
43	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
44	EQUIP_CD	Character(4)	VARCHAR2(4) NOT NULL	Equipment/Materials Code
45	QUANTITY	Number(3,0)	SMALLINT NOT NULL	Quantity
46	EEQUANTITY	Number(3,0)	SMALLINT NOT NULL	Quantity
47	EXPENSE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Expense Type
48	LIMIT_SW_FRA	Character(1)	VARCHAR2(1) NOT NULL	Limited Amount
49	LIMIT_AMT_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Limit Amount
50	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
51	BILLING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Status A=Active H=Hold Billing I=Inactive
52	COMPANY_COST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Company Cost
53	CHARGEABLE_CST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Chargeable Cost
54	LIMIT_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
55	LIMIT_COST_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Cost Unit
56	TRN_IMPUTABLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Chargeable
57	EXCHNG_TO_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
58	AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Dollar Amount
59	LOCAL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
60	LOCAL_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Billed on Department
61	COST_VAR1	Number(19,3)	DECIMAL(18,3) NOT NULL	Variable Cost
62	TRN_2483_COST	Number(15,2)	DECIMAL(14,2) NOT NULL	French Training Report
63	TOTAL_DURATION	Number(10,1)	DECIMAL(9,1) NOT NULL	Total Duration
64	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
65	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
66	ROOM_CD	Character(6)	VARCHAR2(6) NOT NULL	Room Code
67	CUT_SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Cut Session Nbr
68	ROW_COUNT2	Number(8,0)	INTEGER NOT NULL	Number of rows.
69	TRN_EECHARG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Employee Chargeable Flag
70	TRN_EXT_EXPNS_TBL	Character(15)	VARCHAR2(15) NOT NULL	French Report 2483 : External Expense record
71	TRN_SYS_UPDATED	Character(1)	VARCHAR2(1) NOT NULL	French Report 2483 : System Maintained
72	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
73	ROW_COUNT3	Number(8,0)	INTEGER NOT NULL	Number of rows.
74	TRN_VENDOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Vendor Type C=Consulting Firm E=Equipment Rental F=Facilities Rentals I=Outside Instructors M=Training Materials O=Other P=Training Provider S=Guest Speaker T=Financing Fund
75	COMPANY_ALT	Character(3)	VARCHAR2(3) NOT NULL	Company
76	COURSE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Course Type C=Continuing Education D=Skill Development E=Experience Validation F=Functional M=Management Development O=Competency check S=Supervisory Skills T=Technical