HR_OWS_EMPL_VW

(SQL View)
 Index Back

OWS Enrolled

Persons currently enrolled in Oracle Workforce Scheduling .

SELECT A.EMPLID , A.EMPL_RCD , A.ENROLLED_FLAG FROM PS_PER_ORG_ASG_INT A , PS_INSTALL_INTEGR B WHERE B.INT_APP_TYPE = 'SCH' AND B.INTEGR_PROD_CD = 'OWS' AND B.INSTALLED_FLAG = 'Y' AND A.INT_APP_TYPE = B.INT_APP_TYPE AND A.INTEGR_PROD_CD = B.INTEGR_PROD_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 OWS_ENROLL_FLG Character(1) VARCHAR2(1) NOT NULL Oracle Workforce Scheduling Flag

Y/N Table Edit