TRN_T_ACT_ESP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRN_T_ACTION_ESP	Character(5)	VARCHAR2(5) NOT NULL	Training Action
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	TRN_T_LEVEL_ESP	Character(1)	VARCHAR2(1) NOT NULL	Training Level B=Basic H=Higher Default Value: B
7	TRN_T_TYP_CMP_ESP	Character(1)	VARCHAR2(1) NOT NULL	Company 0=Organizing Entity 1=Bonif Company Default Value: 1
8	TRN_T_TYP_CNTR_ESP	Character(1)	VARCHAR2(1) NOT NULL	Studies Center Y/N Table Edit Default Value: N
9	TRN_T_PRESNTL_ESP	Character(1)	VARCHAR2(1) NOT NULL	Presential Y/N Table Edit
10	TRN_T_LONGDSTN_ESP	Character(1)	VARCHAR2(1) NOT NULL	Long Distance Y/N Table Edit
11	TRN_T_ONLINE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Tele Training Y/N Table Edit
12	TRN_T_MIX_ESP	Character(1)	VARCHAR2(1) NOT NULL	Mixed Y/N Table Edit
13	TRN_T_TRNG_HR1_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Presential Hours
14	TRN_T_TRNG_HR2_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Training Hours
15	TRN_T_TRNG_HR3_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Tele-training Hours
16	TRN_T_HOURS_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Total Hours
17	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: INSTALLATION.COMPANY Prompt Table: COMPANY_TBL
18	TRN_T_ACTGRP_ESP	Character(6)	VARCHAR2(6) NOT NULL	Group of Actions
19	TRN_T_CERTIFCD_ESP	Character(8)	VARCHAR2(8) NOT NULL	Certification Code
20	TRN_T_COMPTNCY_ESP	Character(7)	VARCHAR2(7) NOT NULL	Competency Unit
21	TRN_T_ACT_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Action Type C=Profesnl Qualif Catalog I=Internal Default Value: I
22	TRN_T_MOD_TECH_ESP	Character(1)	VARCHAR2(1) NOT NULL	Information Technology Y/N Table Edit
23	TRN_T_MOD_RISK_ESP	Character(1)	VARCHAR2(1) NOT NULL	Occupational Risk Prevention Y/N Table Edit
24	TRN_T_MOD_ENV_ESP	Character(1)	VARCHAR2(1) NOT NULL	Environmental Awareness Y/N Table Edit
25	TRN_T_MOD_EQTY_ESP	Character(1)	VARCHAR2(1) NOT NULL	Equality Promotion Y/N Table Edit
26	TRN_T_HRS_TECH_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Technology Module Hours
27	TRN_T_HRS_ENV_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Environment Module Hours
28	TRN_T_HRS_RISK_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Risk Prevention Module Hours
29	TRN_T_HRS_EQTY_ESP	Number(7,2)	DECIMAL(6,2) NOT NULL	Equity Promotion Module Hours
30	TRN_T_RD_ESP	Character(11)	VARCHAR2(11) NOT NULL	Law Id
31	TRN_T_ACT_CLSS_ESP	Character(1)	VARCHAR2(1) NOT NULL	Action Class 0=Generic 1=Specific Default Value: 0
32	TRN_T_OBJECTVS_ESP	Character(254)	VARCHAR2(254) NOT NULL	Objectives
33	TRN_T_ACCESS_ESP	Character(1)	VARCHAR2(1) NOT NULL	Access Type 0=Without Credentials 1=With Credentials Default Value: 0
34	TRN_T_URL_ESP	Character(254)	VARCHAR2(254) NOT NULL	URL
35	TRN_T_USER_ESP	Character(50)	VARCHAR2(50) NOT NULL	User
36	TRN_T_PASSWORD_ESP	Character(20)	VARCHAR2(20) NOT NULL	Password
37	TRN_T_KEY_ESP	Character(20)	VARCHAR2(20) NOT NULL	Key Code
38	TRN_T_PRF_AREA_ESP	Character(4)	VARCHAR2(4) NOT NULL	Professional Area Prompt Table: TRN_AREA_ESP_VW
39	TRN_T_MODALITY_ESP	Character(1)	VARCHAR2(1) NOT NULL	Method Type 1=Presential 2=Long Distance 2=Long Distance 3=Internet 3=Tele-training 9=Mix
40	TRN_T_VENDOR2_ESP	Character(6)	VARCHAR2(6) NOT NULL	Vendor Id Prompt Table: TRN_T_VND_ESPVW
41	TRN_T_COMMENTS_ESP	Character(254)	VARCHAR2(254) NOT NULL	Comments
42	TRN_T_CONTENTS_ESP	Long Character	CLOB	Contents