PER_ORG_ASGN_CV (SQL View)	Index Back
PER_ORG_ASGN Clairvia Clone of PER_ORG_ASGN record for Clairvia Fullsync message

PER_ORG_ASGN_CV

(SQL View)

PER_ORG_ASGN Clairvia

Clone of PER_ORG_ASGN record for Clairvia Fullsync message

SELECT ASGN.EMPLID , ASGN.EMPL_RCD , ASGN.PER_ORG , ASGN.ORG_INSTANCE_ERN , ASGN.POI_TYPE , ASGN.BENEFIT_RCD_NBR , ASGN.HOME_HOST_CLASS , ASGN.CMPNY_DT_OVR , ASGN.CMPNY_SENIORITY_DT , ASGN.SERVICE_DT_OVR , ASGN.SERVICE_DT , ASGN.SEN_PAY_DT_OVR , ASGN.SENIORITY_PAY_DT , ASGN.PROF_EXPERIENCE_DT , ASGN.LAST_VERIFICATN_DT , ASGN.PROBATION_DT , ASGN.LAST_INCREASE_DT , ASGN.OWN_5PERCENT_CO , ASGN.BUSINESS_TITLE , ASGN.POSITION_PHONE , ASGN.LAST_CHILD_UPDDTM FROM PS_PER_ORG_ASGN ASGN , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = ASGN.EMPLID AND ASG.EMPL_RCD = ASGN.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
Prompt Table: PERSON

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

3 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
Default Value: PER_ORG_INST.PER_ORG
Prompt Table: PER_ORG_VW

4 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.
Default Value: PER_ORG_INST.ORG_INSTANCE_ERN
Prompt Table: PER_ORG_INST

5 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL

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

7 HOME_HOST_CLASS Character(1) VARCHAR2(1) NOT NULL Home/Host Classification
M=Home
S=Host
Default Value: M

8 CMPNY_DT_OVR Character(1) VARCHAR2(1) NOT NULL Used to indicate whether the user has overridden the Company Seniority Pay Date If they have, then the field will not be set by the JOB peoplecode.
Y/N Table Edit
Default Value: N

9 CMPNY_SENIORITY_DT Date(10) DATE Company Seniority Date

10 SERVICE_DT_OVR Character(1) VARCHAR2(1) NOT NULL Used to indicate whether the user has overridden the Service Date If they have, then the field will not be set by the JOB peoplecode.
Y/N Table Edit
Default Value: N

11 SERVICE_DT Date(10) DATE Service Date

12 SEN_PAY_DT_OVR Character(1) VARCHAR2(1) NOT NULL Used to indicate whether the user has overridden the Seniority Pay Date If they have, then the field will not be set by the JOB peoplecode.
Y/N Table Edit
Default Value: N

13 SENIORITY_PAY_DT Date(10) DATE Seniority Pay Calc Date

14 PROF_EXPERIENCE_DT Date(10) DATE Professional Experience Date

15 LAST_VERIFICATN_DT Date(10) DATE Last Verification Date

16 PROBATION_DT Date(10) DATE Probation Date

17 LAST_INCREASE_DT Date(10) DATE Date Last Increase

18 OWN_5PERCENT_CO Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing.
Y/N Table Edit
Default Value: N

19 BUSINESS_TITLE Character(30) VARCHAR2(30) NOT NULL Business Title

20 POSITION_PHONE Character(24) VARCHAR2(24) NOT NULL Phone number for the Position

21 LAST_CHILD_UPDDTM DateTime(26) TIMESTAMP Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: 0
3	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest Default Value: PER_ORG_INST.PER_ORG Prompt Table: PER_ORG_VW
4	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. Default Value: PER_ORG_INST.ORG_INSTANCE_ERN Prompt Table: PER_ORG_INST
5	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
6	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.
7	HOME_HOST_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Home/Host Classification M=Home S=Host Default Value: M
8	CMPNY_DT_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Company Seniority Pay Date If they have, then the field will not be set by the JOB peoplecode. Y/N Table Edit Default Value: N
9	CMPNY_SENIORITY_DT	Date(10)	DATE	Company Seniority Date
10	SERVICE_DT_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Service Date If they have, then the field will not be set by the JOB peoplecode. Y/N Table Edit Default Value: N
11	SERVICE_DT	Date(10)	DATE	Service Date
12	SEN_PAY_DT_OVR	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether the user has overridden the Seniority Pay Date If they have, then the field will not be set by the JOB peoplecode. Y/N Table Edit Default Value: N
13	SENIORITY_PAY_DT	Date(10)	DATE	Seniority Pay Calc Date
14	PROF_EXPERIENCE_DT	Date(10)	DATE	Professional Experience Date
15	LAST_VERIFICATN_DT	Date(10)	DATE	Last Verification Date
16	PROBATION_DT	Date(10)	DATE	Probation Date
17	LAST_INCREASE_DT	Date(10)	DATE	Date Last Increase
18	OWN_5PERCENT_CO	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee owns 5% or more of the company. This value is used in nondiscrimination testing. Y/N Table Edit Default Value: N
19	BUSINESS_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Business Title
20	POSITION_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Phone number for the Position
21	LAST_CHILD_UPDDTM	DateTime(26)	TIMESTAMP	Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.