REG_REGIONDefault Value: ESP
EFFDTDefault Value: %date
TRN_T_MODALITY_ESP1=Presential
2=Long Distance
3=Internet
9=Mix
Default Value: EUR
Prompt Table: CURRENCY_CD_TBL
TRN_T_BONS_ESP(SQL Table) |
Index Back |
|---|---|
Tripartite Foundation DataMaximum bonus amount Tripartite Foundation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REG_REGION |
Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: ESP |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | TRN_T_MODALITY_ESP |
Character(1) | VARCHAR2(1) NOT NULL |
Method Type
1=Presential 2=Long Distance 3=Internet 9=Mix |
| 4 | TRN_T_BSIC_AMT_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Basic Level Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR Prompt Table: CURRENCY_CD_TBL |
| 6 | TRN_T_HIGH_AMT_ESP | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | High Level Amount |