BAS_SUMM_EML_VW (SQL View)	Index Back
Statement Summary Email View

BAS_SUMM_EML_VW

(SQL View)

Statement Summary Email View

SELECT BAS_STMT_TYPE , SCHED_ID , EMPLID , BENEFIT_RCD_NBR , EVENT_ID , EFFDT , EFFSEQ , PROCESS_INSTANCE , EVENT_DT , BENEFIT_PROGRAM , BAS_PROCESS_STATUS , CONFIRM_NOTIFY_DT , EVENT_CLASS , 'BAS_STMT_SUMM' FROM PS_BAS_STMT_SUMM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BAS_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Benefits Statement Type
C=Confirmation Statement
E=Enrollment Preview
S=Submitted Enrollment
Default Value: C

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

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

4 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.

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

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Default Value: 0

9 EVENT_DT Date(10) DATE Event Date

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

11 BAS_PROCESS_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
AE=Program Elig Assign Error
AN=Program Elig Assign None
AS=Program Elig Assigned
EE=Election Error
ET=Entered
FA=Finalized - Benefit Pgm None
FE=Finalized - Enrolled
FP=Finalized - Prepared None
NT=Notified
PE=Prepare Error
PR=Prepared
RE=Re-Enter

12 CONFIRM_NOTIFY_DT Date(10) DATE Date Notified of Confirmation

13 EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL Event Classification

14 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BAS_STMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Statement Type C=Confirmation Statement E=Enrollment Preview S=Submitted Enrollment Default Value: C
2	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	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.
5	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: 0
9	EVENT_DT	Date(10)	DATE	Event Date
10	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
11	BAS_PROCESS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status AE=Program Elig Assign Error AN=Program Elig Assign None AS=Program Elig Assigned EE=Election Error ET=Entered FA=Finalized - Benefit Pgm None FE=Finalized - Enrolled FP=Finalized - Prepared None NT=Notified PE=Prepare Error PR=Prepared RE=Re-Enter
12	CONFIRM_NOTIFY_DT	Date(10)	DATE	Date Notified of Confirmation
13	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification
14	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).