COUNTRYPrompt Table: GP_USER_CNTR_VW
Y/N Table Edit
Default Value: N
GP_SUFFIX(SQL Table) |
Index Back |
|---|---|
Element SuffixElement Suffix |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_USER_CNTR_VW |
| 2 | SUFFIX_SEPARATOR | Character(1) | VARCHAR2(1) NOT NULL | Element Suffix Separator |
| 3 | DFLT_CTRY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Y/N
Identifies a GP SUFFIX row as default, meaning it will be used for countries that do not have their own defined row in GP SUFFIX
Y/N Table Edit Default Value: N |
| 4 | CMPNT_BASE_SFX | Character(5) | VARCHAR2(5) NOT NULL | suffix appended to name of Base element associated with a given earning or deduction element |
| 5 | CMPNT_PCT_SFX | Character(5) | VARCHAR2(5) NOT NULL | suffix appended to name of Percent element associated with a given earning or deduction element |
| 6 | CMPNT_RATE_SFX | Character(5) | VARCHAR2(5) NOT NULL | suffix appended to name of Rate element associated with a given earning or deduction element |
| 7 | CMPNT_UNIT_SFX | Character(5) | VARCHAR2(5) NOT NULL | suffix appended to Unit element associated with a given earning or deduction |
| 8 | DED_PYBK_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Deduction Suffix |
| 9 | DED_ANT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Deduction Suffix |
| 10 | DED_ANTARR_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Deduction Suffix |
| 11 | PTD_AMT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element PTD Suffix |
| 12 | PTD_UNIT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element PTD Suffix |
| 13 | PTD_AMT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element PTD Suffix |
| 14 | PTD_UNIT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element PTD Suffix |
| 15 | MTD_AMT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element MTD Suffix |
| 16 | MTD_UNIT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element MTD Suffix |
| 17 | MTD_AMT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element MTD Suffix |
| 18 | MTD_UNIT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element MTD Suffix |
| 19 | QTD_AMT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element QTD Suffix |
| 20 | QTD_UNIT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element QTD Suffix |
| 21 | QTD_AMT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element QTD Suffix |
| 22 | QTD_UNIT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element QTD Suffix |
| 23 | YTD_AMT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element YTD Suffix |
| 24 | YTD_UNIT_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element YTD Suffix |
| 25 | YTD_AMT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element YTD Suffix |
| 26 | YTD_UNIT_SFX_FSCL | Character(5) | VARCHAR2(5) NOT NULL | Element YTD Suffix |
| 27 | DED_ARR_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Deduction Suffix |
| 28 | ENTL_UNIT_PD_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Accum Suffix |
| 29 | ENTL_UNIT_ADJ_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Accum Suffix |
| 30 | BAL_ACM_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Accum Suffix |
| 31 | ENTL_ACM_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Accum Suffix |
| 32 | ADJ_ACM_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Accum Suffix |
| 33 | TAKE_ACM_SFX | Character(5) | VARCHAR2(5) NOT NULL | Element Accum Suffix |