COURSEPrompt Table: CRSE_SESSN_SRCH
SESSION_NBRPrompt Table: TRN_T_ACT_ESP
Prompt Table: TRN_T_GRP_VWESP
D=Other Directs Expenses
E=Equipment
F=Facility
I=Instructor
O=Other Indirect Expenses
V=Vendor
Prompt Table: COST_UNIT_TBL
TRN_T_SUMM_ESP(SQL Table) |
Index Back |
|---|---|
Tripartite Foundation SessionTripartite Foundation data for courses and sessions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: CRSE_SESSN_SRCH |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 3 | TRN_T_ACTION_ESP | Character(5) | VARCHAR2(5) NOT NULL |
Training Action
Prompt Table: TRN_T_ACT_ESP |
| 4 | TRN_T_GROUP_ESP | Character(5) | VARCHAR2(5) NOT NULL |
Training Group
Prompt Table: TRN_T_GRP_VWESP |
| 5 | TRN_T_TYP_EXP_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Expenses Type
D=Other Directs Expenses E=Equipment F=Facility I=Instructor O=Other Indirect Expenses V=Vendor |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | PER_UNIT_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Per Unit Cost |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | COST_UNIT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Cost Unit
Prompt Table: COST_UNIT_TBL |
| 10 | COSTUNIT_CONVERTED | Number(19,3) | DECIMAL(18,3) NOT NULL | Converted Cost Unit |
| 11 | COST_UNIT_CD1 | Character(10) | VARCHAR2(10) NOT NULL | Cost Unit |
| 12 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | TRN_T_TRNG_HR1_ESP | Number(7,2) | DECIMAL(6,2) NOT NULL | Training Hours |
| 14 | TRN_T_AMOUNT_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount |
| 15 | TRN_T_STD_SESN_ESP | Number(3,0) | SMALLINT NOT NULL | Students/Session |