PY_EMPL_ST_PRTY (SQL Table)	Index Back
Insights Employee Status Insights Employee Status Category Setup

PY_EMPL_ST_PRTY

(SQL Table)

Insights Employee Status

Insights Employee Status Category Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_CATGRY_TYPE Character(3) VARCHAR2(3) NOT NULL Category type for Chatbot category setup
D=Deductions
E=Earnings
G=Garnishment
S=Employee Status

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

3 PY_CTGRY_USED_BY Character(1) VARCHAR2(1) NOT NULL Category Used By
C=Chatbot
K=Insights
Default Value: C

4 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

5 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_CATGRY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Category type for Chatbot category setup D=Deductions E=Earnings G=Garnishment S=Employee Status
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	PY_CTGRY_USED_BY	Character(1)	VARCHAR2(1) NOT NULL	Category Used By C=Chatbot K=Insights Default Value: C
4	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
5	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority