PERORGASGHP_CV(SQL View) |
Index Back |
|---|---|
PER_ORG_ASG_HP MSG ClairviaClone of PER_ORG_ASG_HP record for Clairvia Fullsync message |
| SELECT HP.EMPLID , HP.EMPL_RCD , HP.TENURE_ACCR_FLG , HP.FTE_TENURE , HP.EG_GROUP , HP.FTE_FLX_SRVC , HP.APPOINT_END_DT , HP.CONTRACT_LENGTH FROM PS_PER_ORG_ASG_HP HP , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = HP.EMPLID AND ASG.EMPL_RCD = HP.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: PER_ORG_ASGN |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN |
| 3 | TENURE_ACCR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Accrue Tenure Services
N=Do Not Accrue Y=Accrue Tenure Default Value: N |
| 4 | FTE_TENURE | Number(4,2) | DECIMAL(3,2) NOT NULL | FTE for Tenure Accrual |
| 5 | EG_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
Service Calculation Group
Prompt Table: EG_CALC_SVC_VW |
| 6 | FTE_FLX_SRVC | Number(4,2) | DECIMAL(3,2) NOT NULL | FTE for Flex Service Accrual |
| 7 | APPOINT_END_DT | Date(10) | DATE | Appointment End Date |
| 8 | CONTRACT_LENGTH | Character(1) | VARCHAR2(1) NOT NULL |
Contract Length
0=Not Applicable 1=<9 Month 1=<9 Month 2=9-10 Month 2=9-10 Month 3=11-12 Month 3=11-12 Month 4=9 Month 5=10 Month 6=11 Month 7=12 Month 8=>12 Month Default Value: 0 |