TRN_T_ACT_WRK

(SQL Table)
 Index Back

FT Action Work Table

FT Action Work Table is a table to store the FT data for XML files.

# 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 TRN_T_PRESNTL_ESP Character(1) VARCHAR2(1) NOT NULL Presential

Y/N Table Edit

4 TRN_T_LONGDSTN_ESP Character(1) VARCHAR2(1) NOT NULL Long Distance

Y/N Table Edit

5 TRN_T_ONLINE_ESP Character(1) VARCHAR2(1) NOT NULL Tele Training

Y/N Table Edit

6 TRN_T_MIX_ESP Character(1) VARCHAR2(1) NOT NULL Mixed

Y/N Table Edit

7 TRN_T_MODALITY_ESP Character(1) VARCHAR2(1) NOT NULL Method Type
1=Presential
2=Long Distance
3=Internet
9=Mix
8 TRN_T_TRNG_HR1_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
9 TRN_T_TRNG_HR2_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
10 TRN_T_TRNG_HR3_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
11 TRN_T_HOURS_ESP Number(7,2) DECIMAL(6,2) NOT NULL Number Hours
12 TRN_T_MOD_TECH_ESP Character(1) VARCHAR2(1) NOT NULL Information Technology

Y/N Table Edit

13 TRN_T_MOD_RISK_ESP Character(1) VARCHAR2(1) NOT NULL Occupational Risk Prevention

Y/N Table Edit

14 TRN_T_MOD_ENV_ESP Character(1) VARCHAR2(1) NOT NULL Environmental Awareness

Y/N Table Edit

15 TRN_T_MOD_EQTY_ESP Character(1) VARCHAR2(1) NOT NULL Equality Promotion

Y/N Table Edit

16 TRN_T_HRS_TECH_ESP Number(7,2) DECIMAL(6,2) NOT NULL Technology Module Hours
17 TRN_T_HRS_ENV_ESP Number(7,2) DECIMAL(6,2) NOT NULL Environment Module Hours
18 TRN_T_HRS_RISK_ESP Number(7,2) DECIMAL(6,2) NOT NULL Risk Prevention Module Hours
19 TRN_T_HRS_EQTY_ESP Number(7,2) DECIMAL(6,2) NOT NULL Equity Promotion Module Hours