COURSEPrompt Table: CRSE_SESSN_SRCH
SESSION_NBRCOMPANYPrompt Table: COMPANY_TBL
XML_TRN_COST_VW(SQL View) |
Index Back |
|---|---|
FT Session Costs by CompanyTripartite Foundation. Session Costs by Company |
| SELECT A.COURSE , A.SESSION_NBR , A.COMPANY , B.FISCAL_ID_CD , A.TRN_T_DRCT_CST_ESP , A.TRN_T_ASCT_CST_ESP , A.TRN_T_PRSN_CST_ESP , A.TRN_T_ORGN_CST_ESP FROM %Table(TRN_T_COSTS_ESP) A , %Table(COMPANY_TBL) B WHERE B.COMPANY = A.COMPANY AND B.EFF_STATUS = 'A' AND B. EFFDT = ( SELECT MAX(CMP.EFFDT) FROM %Table(COMPANY_TBL) CMP WHERE CMP.COMPANY = B.COMPANY AND CMP.EFFDT <= %CurrentDateIn) |
| # | 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: COMPANY_TBL |
| 4 | FISCAL_ID_CD | Character(10) | VARCHAR2(10) NOT NULL | Fiscal Identification Code |
| 5 | TRN_T_DRCT_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Direct Costs |
| 6 | TRN_T_ASCT_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Indirect Costs |
| 7 | TRN_T_PRSN_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Personnel Costs |
| 8 | TRN_T_ORGN_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Organizational Costs |