HCI_PERORGASGNV(SQL View) |
Index Back |
|---|---|
HCI Per Org Assign ViewCampus Integration Per Org Assign View |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.PER_ORG ,A.ORG_INSTANCE_ERN ,A.POI_TYPE ,A.BENEFIT_RCD_NBR ,A.HOME_HOST_CLASS ,A.CMPNY_DT_OVR ,A.CMPNY_SENIORITY_DT ,A.SERVICE_DT_OVR ,A.SERVICE_DT ,A.SEN_PAY_DT_OVR ,A.SENIORITY_PAY_DT ,A.PROF_EXPERIENCE_DT ,A.LAST_VERIFICATN_DT ,A.PROBATION_DT ,A.LAST_INCREASE_DT ,A.OWN_5PERCENT_CO ,A.BUSINESS_TITLE ,A.POSITION_PHONE FROM PS_PER_ORG_ASGN A |
| # | 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 Rcd Nbr
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 |