PCMP_OBSMOD_ELM(SQL Table) |
Index Back |
---|---|
Prof Comp Obs. Model ElementsUsed in the Professional Compliance module. Observation model elements. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
2 | PCMP_OBS_MODEL | Character(8) | VARCHAR2(8) NOT NULL | Used in the Professional Compliance module. Observation model name. |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | PCMP_OBS_ELEM | Character(8) | VARCHAR2(8) NOT NULL |
Used in the Professional Compliance module.
Observation element.
Prompt Table: PCMP_OBS_ELEMVW |
5 | PCMP_OBS_ELEM_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Used in the Professioanl Compliance module.
Observation element required status.
N=No Y=Yes Default Value: Y |