UPG_PA_CALC_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALC_NAME	Character(20)	VARCHAR2(20) NOT NULL	Calculation Name
2	CALC_SEQ_NUM	Number(9,0)	DECIMAL(9) NOT NULL	Calc Seq Num
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	LIST_NM	Character(10)	VARCHAR2(10) NOT NULL	Name of group of employees
5	GROUP_NAME	Character(10)	VARCHAR2(10) NOT NULL	Group Name
6	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
7	REL_CALC_NAME	Character(10)	VARCHAR2(10) NOT NULL	Related Calc Name
8	REL_CALC_BEN_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Related Calc Benefit Percent
9	CUSTOM_STMT_NAME	Character(10)	VARCHAR2(10) NOT NULL	Custom Statement Name
10	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
11	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
12	CALCULATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Type G=Pre-defined Group I=Individual L=Pre-defined List
13	CALC_PURPOSE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Purpose B=Beneficiary Payment Forms Q=QDRO Recipient Payment Forms R=Regular Calculation T=Term Vested Payment Forms
14	CALC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Protection Reason C=Final Calculation Candidate E=Estimate Calculation F=Final Calculation O=Other P=Related Primary Calculation Q=QDRO Recipient Candidate
15	CALC_TS	DateTime(26)	TIMESTAMP	Calculation Timestamp
16	CALC_RUN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Calc Run Status
17	CALC_EXEC_TS	DateTime(26)	TIMESTAMP	Calc Execution Timestamp
18	EVENT_DT	Date(10)	DATE	Event Date
19	CALC_REASON	Character(3)	VARCHAR2(3) NOT NULL	Calculation Reason Code DEF=TV-Deferred Pymt DIS=Disability DTH=Death QDR=QDRO Alternate Payee RET=Retirement TER=TV-Immediate Pymt WEB=Web Estimate
20	ASOFDATE	Date(10)	DATE	As of Date
21	CALC_ARCH_DEL_DT	Date(10)	DATE	Archive/Delete Dt
22	CALC_ARCH_DEL_CD	Character(1)	VARCHAR2(1) NOT NULL	Protect Calculation
23	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
24	SS_PIA_CD	Character(1)	VARCHAR2(1) NOT NULL	Calc Soc Sec PIA
25	SSPIA_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
26	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
27	BIRTHDATE	Date(10)	DATE	Date of Birth
28	SPOUSE_BIRTHDATE	Date(10)	DATE	Spouse Birthdate
29	CALC_ALL_PLANS_CD	Character(1)	VARCHAR2(1) NOT NULL	Calculate All Plans
30	VERBOSE_MODE	Character(1)	VARCHAR2(1) NOT NULL	Detailed Worksheet
31	EXT_EMPL_DATA_IND	Character(1)	VARCHAR2(1) NOT NULL	Load External Employee Data
32	DELETE_EXIST_RSLTS	Character(1)	VARCHAR2(1) NOT NULL	Delete Existing Results
33	ADD_YRS_TO_AGE	Number(2,0)	SMALLINT NOT NULL	Number of Years added to Age
34	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
35	PA_SVC_RESTORE	Character(1)	VARCHAR2(1) NOT NULL	Grant Full Service Credit
36	EARN_ASSUMP_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Earnings Amount
37	HRS_ASSMP_AMT	Number(4,0)	SMALLINT NOT NULL	Hours Amount
38	WAGE_BASE_ESCAL_RT	Number(6,2)	DECIMAL(5,2) NOT NULL	Wage Base Escalation Rate
39	SALSC_ASMP_INC_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Salary Scale Percent Increase
40	CPI_ASMP_INC_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	CPI Percent Increase
41	EVENT_AGE	Number(5,2)	DECIMAL(4,2) NOT NULL	Event Age(YY.MM)
42	EVENT_DT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Event Date Alias
43	EVENT_DT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Event Age Alias Type
44	BEN_STMT_DT	Date(10)	DATE	Benefit Statement Date
45	BEN_CMDT_ALIAS	Character(10)	VARCHAR2(10) NOT NULL	Benefit Commencement Dt Alias
46	BEN_CMDT_ALIAST	Character(2)	VARCHAR2(2) NOT NULL	Ben Com Dt Alias Type
47	BEN_CMDT_DATE	Date(10)	DATE	Benefit Commencement Date