SETIDPCMP_OBS_MODELPCMP_OBS_ELEMN=No
Y=Yes
PCMP_OBSMOD_EVW(SQL View) |
Index Back |
|---|---|
Prof Comp Obs. Mod Element VwUsed in the Professional Compliance module. Observation model element view. |
| SELECT A.SETID ,A.PCMP_OBS_MODEL ,B.PCMP_OBS_ELEM ,B.PCMP_OBS_ELEM_REQ FROM PS_PCMP_OBS_MOD_VW A , PS_PCMP_OBSMOD_ELM B WHERE B.SETID=A.SETID AND B.PCMP_OBS_MODEL=A.PCMP_OBS_MODEL AND B.EFFDT=A.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PCMP_OBS_MODEL |
Character(8) | VARCHAR2(8) NOT NULL | Used in the Professional Compliance module. Observation model name. |
| 3 | PCMP_OBS_ELEM |
Character(8) | VARCHAR2(8) NOT NULL | Used in the Professional Compliance module. Observation element. |
| 4 | PCMP_OBS_ELEM_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Used in the Professioanl Compliance module.
Observation element required status.
N=No Y=Yes |