JOB_IND_CV (SQL View)	Index Back
JOB_IND MSG Clairvia Clone of JOB_IND record for Clairvia Fullsync message

JOB_IND_CV

(SQL View)

JOB_IND MSG Clairvia

Clone of JOB_IND record for Clairvia Fullsync message

SELECT JOBI.EMPLID , JOBI.EMPL_RCD , JOBI.EFFDT , JOBI.EFFSEQ , JOBI.MEMBER_STATUS_IND , JOBI.CATEGORY , JOBI.POSITION_HELD_IND , JOBI.COMMENTS FROM PS_JOB_IND JOBI , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = JOBI.EMPLID AND ASG.EMPL_RCD = JOBI.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSON

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

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: JOB.EFFDT

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

5 MEMBER_STATUS_IND Character(1) VARCHAR2(1) NOT NULL This field is used for Membership Status in the Job Data Page
A=Active
I=Inactive
Default Value: I

6 CATEGORY Character(10) VARCHAR2(10) NOT NULL Category Name

7 POSITION_HELD_IND Character(15) VARCHAR2(15) NOT NULL This field is used for position held in the Job Data Page

8 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: JOB.EFFDT
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	MEMBER_STATUS_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used for Membership Status in the Job Data Page A=Active I=Inactive Default Value: I
6	CATEGORY	Character(10)	VARCHAR2(10) NOT NULL	Category Name
7	POSITION_HELD_IND	Character(15)	VARCHAR2(15) NOT NULL	This field is used for position held in the Job Data Page
8	COMMENTS	Long Character	CLOB	Comment