PRIMARY_EMPL_VW (SQL View)	Index Back
Join Primary_Jobs & PER_ORG_PR This view joins the Primary_Jobs table to the Employment table so that the Benefit_Rcd_Nbr field for each job (Empl_Rcd) is available. Used in the on-line validation of the Primary_Jobs table.

PRIMARY_EMPL_VW

(SQL View)

Join Primary_Jobs & PER_ORG_PR

This view joins the Primary_Jobs table to the Employment table so that the Benefit_Rcd_Nbr field for each job (Empl_Rcd) is available. Used in the on-line validation of the Primary_Jobs table.

SELECT A.EMPLID ,A.PRIMARY_JOB_APP ,B.BENEFIT_RCD_NBR ,A.EMPL_RCD ,A.EFFDT ,A.PRIMARY_JOB_IND FROM PS_PRIMARY_JOBS A , PS_PER_ORG_ASGN B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PRIMARY_JOB_APP Character(2) VARCHAR2(2) NOT NULL Denotes the PeopleSoft Application to which this row applies.
BN=Primary Job Application
PA=Pension Administration

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

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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

6 PRIMARY_JOB_IND Character(1) VARCHAR2(1) NOT NULL Primary Job used by applications other than HR
N=Stop Primary
Y=Start Primary

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	PRIMARY_JOB_APP	Character(2)	VARCHAR2(2) NOT NULL	Denotes the PeopleSoft Application to which this row applies. BN=Primary Job Application PA=Pension Administration
3	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.
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	PRIMARY_JOB_IND	Character(1)	VARCHAR2(1) NOT NULL	Primary Job used by applications other than HR N=Stop Primary Y=Start Primary