PA_DFN_FACTOR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEFINITION_NAME	Character(10)	VARCHAR2(10) NOT NULL	VARCHAR2(10) NOT NULL
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	PRIMARY_MORT_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Primary Mortality Basis S=Sex Distinct U=Unisex Default Value: U
4	PRIMARY_MORT_TBL1	Character(10)	VARCHAR2(10) NOT NULL	Table 1 / Male Table Prompt Table: PA_MORT_TABLES
5	PRIMARY_MORT_TBL2	Character(10)	VARCHAR2(10) NOT NULL	Table 2 / Female Table Prompt Table: PA_MORT_TABLES
6	PRIMARY_PCT	Number(3,0)	SMALLINT NOT NULL	% of Table 1 Rate Default Value: 100
7	PRIMARY_AGE1_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Mortality Age Offset - Table 1 A=Alias Name N=Numeric Constant Default Value: N
8	PRIMARY_AGE1	Number(3,0)	SMALLINT NOT NULL	Mortality Age Offset - Table 1
9	PRIMARY_AGE1_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Mortality Age Offset - Table 1 Prompt Table: PA_DURATION
10	PRIMARY_AGE1_DIR	Character(1)	VARCHAR2(1) NOT NULL	Age Offset Direction - Table 1 B=Backwards F=Forwards Default Value: B
11	PRIMARY_AGE1_ALIAT	Character(2)	VARCHAR2(2) NOT NULL	Primary Age 1 Alias Type
12	PRIMARY_AGE2	Number(3,0)	SMALLINT NOT NULL	Mortality Age Offset - Male
13	PRIMARY_AGE2_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Mortality Age Offset - Male Prompt Table: PA_DURATION
14	PRIMARY_AGE2_DIR	Character(1)	VARCHAR2(1) NOT NULL	Age Offset Direction - Male B=Backwards F=Forwards Default Value: B
15	PRIMARY_AGE2_ALIAT	Character(2)	VARCHAR2(2) NOT NULL	Primary Age 2 Alias Type
16	SECOND_MORT_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Secondary Mortality Basis S=Sex Distinct U=Unisex Default Value: U
17	SECOND_MORT_TBL1	Character(10)	VARCHAR2(10) NOT NULL	Table 1 / Male Table Prompt Table: PA_MORT_TABLES
18	SECOND_MORT_TBL2	Character(10)	VARCHAR2(10) NOT NULL	Table 2 / Female Table Prompt Table: PA_MORT_TABLES
19	SECOND_PCT	Number(3,0)	SMALLINT NOT NULL	% of Table 1 Rate Default Value: 100
20	SECOND_AGE1	Number(3,0)	SMALLINT NOT NULL	Mortality Age Offset - Tbl 1
21	SECOND_AGE1_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Mortality Age Offset - Tbl 1 Prompt Table: PA_DURATION
22	SECOND_AGE1_DIR	Character(1)	VARCHAR2(1) NOT NULL	Age Offset Direction - Tbl 1 B=Backwards F=Forwards Default Value: B
23	SECOND_AGE1_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Secondary Age 1 Alias Type
24	SECOND_AGE2	Number(3,0)	SMALLINT NOT NULL	Mortality Age Offset - Male 2
25	SECOND_AGE2_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Mortality Age Offset - Male 2 Prompt Table: PA_DURATION
26	SECOND_AGE2_DIR	Character(1)	VARCHAR2(1) NOT NULL	Age Offset Direction - Male 2 B=Backwards F=Forwards Default Value: B
27	SECOND_AGE2_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Secondary Age 2 Alias Type
28	JOINT_AGE_DIFF_ALS	Character(10)	VARCHAR2(10) NOT NULL	Age Difference Duration Prompt Table: PA_DURATION
29	INTEREST_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Interest Basis C=Use Custom Table Lookup F=Use Flat Rate of P=Use PBGC Grading Structure S=Use Segment Rates U=User Code Default Value: F
30	INTEREST_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Interest Flat Rate Percent
31	INTEREST_AGE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Deferred to Age Field Type A=Alias Name N=Numeric Constant Default Value: N
32	INTEREST_AGE	Number(3,0)	SMALLINT NOT NULL	Deferred to Age
33	INTEREST_AGE_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Deferred to Age Prompt Table: PA_ALIAS_USE
34	INTEREST_AG_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Interest Age Alias Type
35	INTEREST_SCALE	Number(3,0)	SMALLINT NOT NULL	Scaled by
36	INTEREST_CUST_TBL	Character(10)	VARCHAR2(10) NOT NULL	Custom Table Lookup ID Prompt Table: PA_TBL_ALS_SRCH
37	MORTSEGDT_DT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Effective Date Alias to specify Effective Date for Mortality Table and for Segment Rates. Prompt Table: PA_ALIAS_USE
38	MORTSGDT_DT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Effective Date Alias Type that is used to specify Effective Date for Mortality Table and for Segment Rates.
39	SEGRATE_DT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Alias to specify Valuation Date that will be used for Segment Rates Prompt Table: PA_ALIAS_USE
40	SEGRATE_DT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Alias type that is used to specify Valuation Date that will be used for Segment Rates
41	DISCOUNT_INTEREST	Character(1)	VARCHAR2(1) NOT NULL	Discount with Interest Only Y/N Table Edit Default Value: N
42	DISCOUNT_AGE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Discount Age Field Type A=Alias Name N=Numeric Constant Default Value: N
43	DISCOUNT_AGE	Number(3,0)	SMALLINT NOT NULL	Prior to Age
44	DISCOUNT_AGE_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Prior to Age Prompt Table: PA_DURATION
45	DISCOUNT_AG_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Discount Age Alias Type
46	COLA_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Include Cost of Living Y/N Table Edit Default Value: N
47	COLA_AMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	COLA Amount Field Type A=Alias Name N=Numeric Constant Default Value: N
48	COLA_AMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Adjustment of
49	COLA_AMT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Adjustment Of Prompt Table: PA_ALIAS_USE
50	COLA_AMT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Cola Amt Alias Type
51	COLA_AGE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	COLA Commencement Age Type A=Alias Name N=Numeric Constant Default Value: N
52	COLA_AGE	Number(3,0)	SMALLINT NOT NULL	Commencing with Age
53	COLA_AGE_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Commencing with age Prompt Table: PA_DURATION
54	COLA_AGE_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Cola Age Alias Type
55	PAYMENTS_PER_YEAR	Character(2)	VARCHAR2(2) NOT NULL	Payments Per Year BW=26 - Bi-Weekly MM=12 - Monthly QR=4 - Quarterly SA=2 - Semi-Annually SM=24 - Semi-Monthly WW=52 - Weekly YY=1 - Annually Or Single Payment Default Value: MM
56	PAYMENT_TIMING	Character(1)	VARCHAR2(1) NOT NULL	Payment Timing B=Beginning of Period E=End of Period Default Value: B
57	INTERPOLATION_PREC	Character(1)	VARCHAR2(1) NOT NULL	Interpolation Precedence A=Annuities C=Commutation Functions Default Value: C
58	ROUNDING_RULE	Character(10)	VARCHAR2(10) NOT NULL	Rounding Rule