COURSEPrompt Table: CRSE_SESSN_SRCH
SESSION_NBRCOMPANYPrompt Table: TRN_T_CMP_VW
YEARCDDefault Value: EUR
Prompt Table: CURRENCY_CD_TBL
TRN_T_COSTS_ESP(SQL Table) |
Index Back |
|---|---|
FT Session CostsTripartite Foundation. Session Costs |
| # | 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: TRN_T_CMP_VW |
| 4 | YEARCD |
Character(4) | VARCHAR2(4) NOT NULL | Calendar Year |
| 5 | TRN_T_CMP_STUD_ESP | Number(4,0) | SMALLINT NOT NULL | Company Students |
| 6 | TRN_T_DRCT_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Direct Costs |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR Prompt Table: CURRENCY_CD_TBL |
| 8 | TRN_T_ASCT_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Associated Costs |
| 9 | TRN_T_PRSN_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Personnel Costs |
| 10 | TRN_T_TRNG_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Training Costs |
| 11 | TRN_T_RED_CST_ESP | Number(16,2) | DECIMAL(15,2) NOT NULL | Cost To Reduce |
| 12 | TRN_T_PRVT_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Private Contribution |
| 13 | TRN_T_BNS_AMNT_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Max Bonus Amount |