PCMP_REASS_AET (SQL Table)	Index Back
Prof Comp Reassignment AET Used in the Professional Compliance module. State record used in the reassignment application engine programs.

PCMP_REASS_AET

(SQL Table)

Prof Comp Reassignment AET

Used in the Professional Compliance module. State record used in the reassignment application engine programs.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 PCMP_REASS_EMPLID Character(11) VARCHAR2(11) NOT NULL Used in the Professional Compliance module. Holds the EMPLID of the regulated individual or Manager/Supervisor that needs to be reassigned for the reassign application engine programs.

3 PCMP_REASS_EMPREC Number(3,0) SMALLINT NOT NULL Used in the Professional Compliance module. Holds the employee record number for reassigning regulated individuals.

4 PCMP_TARGET_EMPLID Character(11) VARCHAR2(11) NOT NULL Used in the Professional Compliance module. Holds the EMPLID of the target Manager/Supervisor for the reassign application engine programs.

5 PCMP_REASS_OPT Character(1) VARCHAR2(1) NOT NULL Used in the Professional Compliance module. Option flag indicating whether a single regulated individual is being reassigned, or all regulated individuals reporting to the given Emplid.
A=All Individuals
S=Single Individual

6 PCMP_MGR_SUPER_ID Character(11) VARCHAR2(11) NOT NULL Professional Compliance Manager/Supervisor ID - Used in the Professional Compliance module. Holds the EMPLID of the Manager/Supervisor.

7 PCMP_MGR_SUPER Character(1) VARCHAR2(1) NOT NULL Professional Compliance Manager/Supervisor - Used within the Professional Compliance module. Identifies whether the role is that of a Manager, or a Supervisor.
M=Manager
S=Supervisor

8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

10 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.

11 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.

12 PCMP_ASSIGNED_DT Date(10) DATE Professional Compliance Assigned Date - Used within the Professional Compliance module. Contains the date that a Manager/Supervisor was assignd in the compliance process.
Default Value: %date

13 PCMP_RI_STATUS Character(1) VARCHAR2(1) NOT NULL Professional Compliance Regulated Individual Status - Used in the Professional Compliance module. Defines whether the individual is active/inactive within the compliance process.
A=Active
I=Inactive
Default Value: A

14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

15 AE_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL Test Flag

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PCMP_REASS_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Used in the Professional Compliance module. Holds the EMPLID of the regulated individual or Manager/Supervisor that needs to be reassigned for the reassign application engine programs.
3	PCMP_REASS_EMPREC	Number(3,0)	SMALLINT NOT NULL	Used in the Professional Compliance module. Holds the employee record number for reassigning regulated individuals.
4	PCMP_TARGET_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Used in the Professional Compliance module. Holds the EMPLID of the target Manager/Supervisor for the reassign application engine programs.
5	PCMP_REASS_OPT	Character(1)	VARCHAR2(1) NOT NULL	Used in the Professional Compliance module. Option flag indicating whether a single regulated individual is being reassigned, or all regulated individuals reporting to the given Emplid. A=All Individuals S=Single Individual
6	PCMP_MGR_SUPER_ID	Character(11)	VARCHAR2(11) NOT NULL	Professional Compliance Manager/Supervisor ID - Used in the Professional Compliance module. Holds the EMPLID of the Manager/Supervisor.
7	PCMP_MGR_SUPER	Character(1)	VARCHAR2(1) NOT NULL	Professional Compliance Manager/Supervisor - Used within the Professional Compliance module. Identifies whether the role is that of a Manager, or a Supervisor. M=Manager S=Supervisor
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
10	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.
11	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.
12	PCMP_ASSIGNED_DT	Date(10)	DATE	Professional Compliance Assigned Date - Used within the Professional Compliance module. Contains the date that a Manager/Supervisor was assignd in the compliance process. Default Value: %date
13	PCMP_RI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Professional Compliance Regulated Individual Status - Used in the Professional Compliance module. Defines whether the individual is active/inactive within the compliance process. A=Active I=Inactive Default Value: A
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag