PCMP_TYPE_JOBCD(SQL Table) |
Index Back |
---|---|
Prof Comp Jocode ComplianceUsed in the Professional Compliance module. Contains the default compliance types associated with Jobcode. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: JOBCODE_TBL.SETID |
2 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Default Value: JOBCODE_TBL.JOBCODE |
3 | 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_VW |