1. Tables and Views
  2. PSC_COM_JOBSECTN_PROF_GRP_V

PSC_COM_JOBSECTN_PROF_GRP_V

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: VIEW

Columns

Name

PERSON_ID

AGENCY_ID

JOB_FUNC_ID

JOB_FUNC_SEC_ID

JOB_FUNC_SECTN_VALUE

Query

SQL_Statement

select PERSON_ID,agency_id,JOB_FUNC_ID,JOB_FUNC_SEC_ID,JOB_FUNC_SECTN_VALUE

FROM psc_com_job_func_assign

WHERE enabled_flag='Y'

union

select prof.PERSON_ID,prof.agency_id,grp.job_func_id,GRP.JOB_FUNC_SEC_ID,GRP.JOB_FUNC_SECTN_VALUE

from PSC_COM_PERSON_PROF prof,psc_com_job_grp_func_SEC grp

where prof.JOB_FUNC_GRP_ID=grp.JOB_FUNC_GRP_ID

and grp.enabled_flag='Y'