JOB_MIL_CV (SQL View)	Index Back
JOB_MIL MSG Clairvia Clone of JOB_MIL record for Clairvia Fullsync message

JOB_MIL_CV

(SQL View)

JOB_MIL MSG Clairvia

Clone of JOB_MIL record for Clairvia Fullsync message

SELECT JOBM.EMPLID , JOBM.EMPL_RCD , JOBM.EFFDT , JOBM.EFFSEQ , JOBM.MIL_SVC_COMP_CD , JOBM.MIL_CMP_CATEGORY , JOBM.JOB_FAMILY , JOBM.JOB_FUNCTION , JOBM.JOB_SUB_FUNC , JOBM.MIL_RANK , JOBM.MIL_RANK_ENTRY_DT , JOBM.MIL_WORN_RANK , JOBM.MIL_WORN_RNK_TYPE , JOBM.MIL_SKILL_GRADE , JOBM.LASTUPDOPRID FROM PS_JOB_MIL JOBM , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = JOBM.EMPLID AND ASG.EMPL_RCD = JOBM.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: %date

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

5 MIL_SVC_COMP_CD Character(4) VARCHAR2(4) NOT NULL Service Component
Prompt Table: MIL_SVC_CMP_VW

6 MIL_CMP_CATEGORY Character(4) VARCHAR2(4) NOT NULL Component Category
Prompt Table: MIL_CMP_CAT_VW

7 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
Prompt Table: JOB_FAMILY_TBL

8 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code
Prompt Table: JOBFUNCTION_TBL

9 JOB_SUB_FUNC Character(3) VARCHAR2(3) NOT NULL Job sub Function
Prompt Table: JOB_SUB_FNC_VW

10 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
Prompt Table: MIL_RANK_TBL

11 MIL_RANK_ENTRY_DT Date(10) DATE The employee's date when the new rank was given

12 MIL_WORN_RANK Character(5) VARCHAR2(5) NOT NULL Worn Rank
Prompt Table: MIL_WORN_RNK_VW

13 MIL_WORN_RNK_TYPE Character(2) VARCHAR2(2) NOT NULL Worn Rank Type
Prompt Table: MIL_WRN_TYP_TBL

14 MIL_SKILL_GRADE Character(2) VARCHAR2(2) NOT NULL Skill Grade
Prompt Table: MIL_SKL_GRD_TBL

15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	MIL_SVC_COMP_CD	Character(4)	VARCHAR2(4) NOT NULL	Service Component Prompt Table: MIL_SVC_CMP_VW
6	MIL_CMP_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Component Category Prompt Table: MIL_CMP_CAT_VW
7	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family Prompt Table: JOB_FAMILY_TBL
8	JOB_FUNCTION	Character(3)	VARCHAR2(3) NOT NULL	Job Function Code Prompt Table: JOBFUNCTION_TBL
9	JOB_SUB_FUNC	Character(3)	VARCHAR2(3) NOT NULL	Job sub Function Prompt Table: JOB_SUB_FNC_VW
10	MIL_RANK	Character(5)	VARCHAR2(5) NOT NULL	Military Rank Prompt Table: MIL_RANK_TBL
11	MIL_RANK_ENTRY_DT	Date(10)	DATE	The employee's date when the new rank was given
12	MIL_WORN_RANK	Character(5)	VARCHAR2(5) NOT NULL	Worn Rank Prompt Table: MIL_WORN_RNK_VW
13	MIL_WORN_RNK_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Worn Rank Type Prompt Table: MIL_WRN_TYP_TBL
14	MIL_SKILL_GRADE	Character(2)	VARCHAR2(2) NOT NULL	Skill Grade Prompt Table: MIL_SKL_GRD_TBL
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.