| # |
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 Means
1=Benefited Company Means
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 |
Training 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 |
Training Hours
|
| 16 |
TRN_T_HOURS_ESP |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number Hours
|
| 17 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Default Value: INSTALLATION.COMPANY
Prompt Table:
COMPANY_TBL
|
| 18 |
TRN_T_ACT_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Type
C=Professnal Qualificatn Catalog
I=Internal
Default Value: I
|
| 19 |
TRN_T_ACTGRP_ESP |
Character(6) |
VARCHAR2(6) NOT NULL |
Group of Actions
|
| 20 |
TRN_T_CERTIFCD_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Certification Code
|
| 21 |
TRN_T_COMPTNCY_ESP |
Character(7) |
VARCHAR2(7) NOT NULL |
Competency Unit
|
| 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_COMMENTS_ESP |
Character(254) |
VARCHAR2(254) NOT NULL |
Comments
|
| 38 |
TRN_T_CONTENTS_ESP |
Long Character |
CLOB |
Contents
|