JOB_MIL_ASGN_VW (SQL View)	Index Back
Military Service by Assignment This view lists all the Military Services by Organizational Assignments

JOB_MIL_ASGN_VW

(SQL View)

Military Service by Assignment

This view lists all the Military Services by Organizational Assignments

SELECT A.EMPLID ,A.ORG_INSTANCE_ERN ,B.EMPL_RCD ,A.MILITARY_SERVICE FROM PS_PER_ORG_INS_MIL A ,PS_PER_ORG_ASGN B WHERE A.EMPLID = B.EMPLID AND A.ORG_INSTANCE_ERN = B.ORG_INSTANCE_ERN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ORG_INSTANCE_ERN Number(3,0) SMALLINT NOT NULL Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ORG_INSTANCE_ERN	Number(3,0)	SMALLINT NOT NULL	Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	MILITARY_SERVICE	Character(8)	VARCHAR2(8) NOT NULL	Military Service