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 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
2 | PCMP_TYPE | 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 | PCMP_REG_AUTH | 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 | LANGUAGE_CD | 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 |