PCMP_RGAUTHCLNG(SQL Table) |
Index Back |
|---|---|
Prof Comp Reg Auth CommentsUsed in the Professional Compliance module. Related language record for PCMP_RGAUTH_COM |
| # | 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(3) | VARCHAR2(3) NOT NULL |
Professiona Compliance Type - Used in the Professional Compliance module.
Identifies the different types of professional complianc within a company.
Prompt Table: PCMP_TYPE |
|
| 3 | Character(10) | VARCHAR2(10) NOT NULL | Professional Compliance Regulatory Authority - Used within the Professional Compliance module. Identifies the body or organization that defines the rules/regulations that a company must apply to its individuals in order for them to become compliant/qualified in that particular field. | |
| 4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 5 | PCMP_REG_AUTH_COMM | Long Character | CLOB | Used in the Professional Compliance module. Comments for the Regulated Authority |