BAS_P_INVT_HST (SQL Table)	Index Back
BAS Partic Investment History BAS_PARTIC_INVT history table, it's used for Archive

BAS_P_INVT_HST

(SQL Table)

BAS Partic Investment History

BAS_PARTIC_INVT history table, it's used for Archive

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

6 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification

7 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

8 INVESTMENT_OPT Character(6) VARCHAR2(6) NOT NULL Investment Option
C=Common Stock - C Fund
F=Thrift Savings Plan - F Fund
G=Thrift Savings Plan - G Fund
I=Thrift Savings Plan - I Fund
S=Thrift Savings Plan - S Fund
Prompt Table: SAVINGS_INV_TBL

9 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

10 EVENT_DT Date(10) DATE NOT NULL Event Date

11 DISPLAY_PLN_SEQ Character(2) VARCHAR2(2) NOT NULL Display Plan-type Sequence

12 ENROLL_ACTION Character(1) VARCHAR2(1) NOT NULL Enroll Action
E=Enroll
N=None
T=Terminate
Default Value: N

13 BAS_ERROR Character(1) VARCHAR2(1) NOT NULL BAS Error Type
Y/N Table Edit
Default Value: N

14 INVESTMENT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Investment Percent

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
6	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
7	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
8	INVESTMENT_OPT	Character(6)	VARCHAR2(6) NOT NULL	Investment Option C=Common Stock - C Fund F=Thrift Savings Plan - F Fund G=Thrift Savings Plan - G Fund I=Thrift Savings Plan - I Fund S=Thrift Savings Plan - S Fund Prompt Table: SAVINGS_INV_TBL
9	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
10	EVENT_DT	Date(10)	DATE NOT NULL	Event Date
11	DISPLAY_PLN_SEQ	Character(2)	VARCHAR2(2) NOT NULL	Display Plan-type Sequence
12	ENROLL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Enroll Action E=Enroll N=None T=Terminate Default Value: N
13	BAS_ERROR	Character(1)	VARCHAR2(1) NOT NULL	BAS Error Type Y/N Table Edit Default Value: N
14	INVESTMENT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Investment Percent