PA_FACTOR_SETUP(SQL Table) |
Index Back |
|---|---|
Factor AliasThis is a setup table containing Factor Aliases. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FACTOR_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Alias Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | ACTUARIAL_ASSUM | Character(10) | VARCHAR2(10) NOT NULL |
Actuarial Assumption Set
Prompt Table: PA_DFN_FACTOR |
| 4 | PRIMARY_AGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Primary Age Type |
| 5 | PRIMARY_AGE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Primary Age Alias
Prompt Table: PA_ALIAS_USE |
| 6 | PRIMARY_AGE_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Primary Age Alias Type |
| 7 | PRIMARY_AGE | Number(10,6) | DECIMAL(9,6) NOT NULL | Primary Age |
| 8 | SECONDRY_AGE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Secondary Age Type |
| 9 | SECONDRY_AGE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Secondary Age Alias
Prompt Table: PA_ALIAS_USE |
| 10 | SECONDRY_AGE_ALIAT | Character(2) | VARCHAR2(2) NOT NULL | Secondary Age Alias Type |
| 11 | SECONDRY_AGE | Number(10,6) | DECIMAL(9,6) NOT NULL | Secondary Age |
| 12 | FROM_FORM_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Form Code
Prompt Table: PA_DFN_FORM_CD |
| 13 | FROM_PMTS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Guaranteed Payments Type |
| 14 | FROM_PMTS_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Guaranteed Payments Alias
Prompt Table: PA_ALIAS_USE |
| 15 | FROM_PMTS_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Guaranteed Payments Alias Type |
| 16 | FROM_GUAR_PMTS | Number(3,0) | SMALLINT NOT NULL | Guaranteed Payments |
| 17 | FROM_PCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Percent Continued Type |
| 18 | FROM_PCT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Percent Continued Alias
Prompt Table: PA_ALIAS_USE |
| 19 | FROM_PCT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Percent Continued Alias Type |
| 20 | FROM_PCT_CONT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent Continued |
| 21 | TO_FORM_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Form Code
Prompt Table: PA_DFN_FORM_CD |
| 22 | TO_PMTS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Guaranteed Payments Type |
| 23 | TO_PMTS_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Guaranteed Payments Alias
Prompt Table: PA_ALIAS_USE |
| 24 | TO_PMTS_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Guaranteed Paymnets Alias Type |
| 25 | TO_GUAR_PMTS | Number(3,0) | SMALLINT NOT NULL | Guaranteed Payments |
| 26 | TO_PCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Percent Continued Type |
| 27 | TO_PCT_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Percent Continued Alias
Prompt Table: PA_ALIAS_USE |
| 28 | TO_PCT_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Percent Continued Aliast Type |
| 29 | TO_PCT_CONT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent Continued |