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 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
|
| 2 | Character(8) | VARCHAR2(8) NOT NULL | Used in the Professional Compliance module. Observation model name. | |
| 3 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 4 | 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 |