COMPANYPrompt Table: COMPANY_TBL
YEARCDCOURSEPrompt Table: TRN_T_CRSE_SRCH
SESSION_NBRPrompt Table: CRSE_SESSN_SRCH
0=Scheduled
1=Initiated
2=Finished
4=Confirmed Sent
TRN_T_CREDT_ESP(SQL Table) |
Index Back |
|---|---|
Training Credit SimulatorTraining Credit Simulator |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | YEARCD |
Character(4) | VARCHAR2(4) NOT NULL | Calendar Year |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: TRN_T_CRSE_SRCH |
| 4 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_SESSN_SRCH |
| 5 | TRN_T_STATUS_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Status
0=Scheduled 1=Initiated 2=Finished 4=Confirmed Sent |
| 6 | TRN_T_RED_CST_ESP | Number(16,2) | DECIMAL(15,2) NOT NULL | Cost To Reduce |
| 7 | TRN_T_PRVT_CST_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Private Contribution |