PRIMARY_JOBS

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	PRIMARY_JOB_IND	Character(1)	VARCHAR2(1) NOT NULL	Primary Job used by applications other than HR N=Stop Primary Y=Start Primary Y/N Table Edit Default Value: Y
6	PRIMARY_FLAG1	Character(1)	VARCHAR2(1) NOT NULL	flag used to indicate employee primary job Y/N Table Edit Default Value: Y
7	PRIMARY_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	flag used to indicate employee primary job Y/N Table Edit Default Value: Y
8	PRIMARY_JOBS_SRC	Character(1)	VARCHAR2(1) NOT NULL	flag used to indicate employee primary job source J=Job M=Maintenance Panel Default Value: J
9	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence Default Value: 0
10	JOB_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	employee employee record number