PCMP_CMP_PLANA(SQL Table) |
Index Back |
---|---|
Prof Comp Compliance Plan AreaUsed in the Professional Compliance module. Company compliance plan area. |
# | 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_PLANSEQ | Number(3,0) | SMALLINT NOT NULL | Used in the Professional Compliance module. Sequence number of compliance plan area. |
4 | PCMP_CMP_PLANAREA | Character(40) | VARCHAR2(40) NOT NULL | Used in the Professional Compliance module. Plan area for company compliance plan. |
5 | PCMP_CMP_PLANNOTES | Long Character | CLOB | Used in the Professional Compliance module. Notes relevant to a compliance plan area. |