COMPANYPCMP_CMP_PLANYRPCMP_CMPPLANVW2(SQL View) |
Index Back |
|---|---|
Prof Comp Compliance PlanUsed in the Professional Compliance module. Company compliance plan. |
| SELECT A.COMPANY ,A.PCMP_CMP_PLANYR ,A.PCMP_CMP_PLANDESC FROM PS_PCMP_CMP_PLAN A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PCMP_CMP_PLANYR |
Number(4,0) | SMALLINT NOT NULL | Used in the Professional Compliance module. Contains the year for the company compliance plan. |
| 3 | PCMP_CMP_PLANDESC | Character(40) | VARCHAR2(40) NOT NULL | Used in the Professional Compliance module. Description of company compliance plan. |