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 |