SAP ABAP Table PS0633 (EEO Complaint Tracking)

Hierarchy

☛ SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
   ⤷ PY-US-PS (Application Component) Öffentlicher Dienst
     ⤷ P10P1 (Package) HR Public Sector USA

Basic Data

Table Category	INTTAB	Structure
Structure	PS0633	Table Relationship Diagram
Short Description	EEO Complaint Tracking

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CASEN	☐	P10_CASEN	CHAR10	CHAR	10	0	EEO Complaint Case Number
2	ANONY	☐	P10_ANONY	XFELD	CHAR	1	0	Flag for Anonymity
3	STATS	☐	P10_EEOCS	P10_EEOCS	CHAR	1	0	Status of EEOC case
4	BASEI	☐	P10_BASEI	P10_EEOCI	CHAR	1	0	Bases and Issues progress icon (traffic light)
5	COUNI	☐	P10_COUNI	P10_EEOCI	CHAR	1	0	Counseling progress icon (traffic light)
6	MEDII	☐	P10_MEDII	P10_EEOCI	CHAR	1	0	Mediation progress icon (traffic light)
7	COMPI	☐	P10_COMPI	P10_EEOCI	CHAR	1	0	Formal Complaint progress icon (traffic light)
8	INVEI	☐	P10_INVEI	P10_EEOCI	CHAR	1	0	Investigation progress icon (traffic light)
9	DECII	☐	P10_DECII	P10_EEOCI	CHAR	1	0	Final Decision progress icon (traffic light)
10	BAS01	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
11	BAS02	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
12	BAS03	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
13	BAS04	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
14	BAS05	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
15	BAS06	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
16	BAS07	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
17	BAS08	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
18	BAS09	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
19	BAS10	☐	P10_BASEC	CHAR3	CHAR	3	0	Code for EEOC Base	T5UPBSEEOCBAIS
20	ISU01	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
21	ISU02	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
22	ISU03	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
23	ISU04	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
24	ISU05	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
25	ISU06	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
26	ISU07	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
27	ISU08	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
28	ISU09	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
29	ISU10	☐	P10_ISSUC	CHAR3	CHAR	3	0	Code for EEOC Issue	T5UPBSEEOCBAIS
30	CADDR	☐	P10_CADDR	AD_ADDRNUM	CHAR	10	0	Address number	*
31	CCNTD	☐	P10_CCNTD	DATUM	DATS	8	0	Counseling contact date
32	CIINT	☐	P10_CIINT	DATUM	DATS	8	0	Counseling initial interview date
33	CFINT	☐	P10_CFINT	DATUM	DATS	8	0	Counseling final interview date
34	CNOFI	☐	P10_CNOFI	DATUM	DATS	8	0	Counseling notice of final interview received (NOFI) date
35	CRECV	☐	P10_CRECV	DATUM	DATS	8	0	Counseling counselor's report received by EEO office date
36	MADDR	☐	P10_MADDR	AD_ADDRNUM	CHAR	10	0	Mediator's address number	*
37	MASGN	☐	P10_MASGN	DATUM	DATS	8	0	Mediation assigned date
38	MCMPL	☐	P10_MCMPL	DATUM	DATS	8	0	Mediation completion date
39	MRSOL	☐	P10_MRSOL	XFELD	CHAR	1	0	Mediation resolution reached flag (Y/N)
40	MRSLD	☐	P10_MRSLD	DATUM	DATS	8	0	Mediation resolution date
41	MCOST	☐	P10_MCOST	P_AMT07V	CURR	13	2	Mediation cost
42	MTYPE	☐	P10_MTYPE	CHAR02	CHAR	2	0	Type of mediation/ADR	T5UPBSEEOMTYP
43	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
44	FDOCN	☐	P10_FDOCN	CHAR15	CHAR	15	0	Formal Complaint docket number
45	FACKD	☐	P10_FACKD	DATUM	DATS	8	0	Formal Complaint acknowledged date
46	FACCD	☐	P10_FACCD	DATUM	DATS	8	0	Formal Complaint accepted/dismissed date
47	FMIXD	☐	P10_FMIXD	XFELD	CHAR	1	0	Formal Complaint mixed case flag (Y/N)
48	FFILE	☐	P10_FFILE	DATUM	DATS	8	0	Formal Complaint filed date
49	FRECV	☐	P10_FRECV	DATUM	DATS	8	0	Formal Complaint received by bureau's EEO date
50	FRMND	☐	P10_FRMND	DATUM	DATS	8	0	Formal Complaint remanded for investigation date
51	FCONSOLID	☐	P10_CONSOLIDATE	XFELD	CHAR	1	0	EEO Complaint consolidated cases
52	REF_CASEN	☐	P10_REFCASEN	CHAR10	CHAR	10	0	Reference Case Number of consolidated cases
53	IADDR	☐	P10_IADDR	AD_ADDRNUM	CHAR	10	0	Investigator's address number	*
54	IASGN	☐	P10_IASGN	DATUM	DATS	8	0	Investigation assigned to investigator date
55	ISTAT	☐	P10_ISTAT	P10_ISTAT	CHAR	1	0	Investigator (Internal/External)
56	IPAID	☐	P10_IPAID	P_AMT07V	CURR	13	2	Investigation paid amount
57	IROID	☐	P10_IROID	DATUM	DATS	8	0	Report of investigation (ROI) issued date
58	IHEAR	☐	P10_IHEAR	DATUM	DATS	8	0	Investigation hearing requested date
59	IFRDH	☐	P10_IFRDH	DATUM	DATS	8	0	Investigation file forwarded to EEOC for hearing date
60	IFADR	☐	P10_IFADR	DATUM	DATS	8	0	Investigation final agency decision (FAD) requested date
61	IFADI	☐	P10_IFADI	DATUM	DATS	8	0	Investigation final agency decision (FAD) issued date
62	IAPPL	☐	P10_IAPPL	DATUM	DATS	8	0	Investigation appeal filed date
63	IDECI	☐	P10_IDECI	DATUM	DATS	8	0	Investigation EEOC decision date
64	IDECR	☐	P10_IDECR	DATUM	DATS	8	0	Investigation EEOC decision received date
65	ICIVL	☐	P10_ICIVL	DATUM	DATS	8	0	Investigation civil action filed date
66	INARC	☐	P10_INARC	DATUM	DATS	8	0	Investigation record sent to NARC date
67	DCLSR	☐	P10_DCLSR	P10_DCLSR	CHAR	2	0	Final Decision closure type	T5UPBSEEOCLTP
68	DACTN	☐	P10_DACTN	P10_DACTN	CHAR	2	0	Final Decision agency action	T5UPBSEEOAGAC
69	DHIRE	☐	P10_DHIRE	P10_DHIRE	CHAR	1	0	Final Decision hire type
70	DPROM	☐	P10_DPROM	P10_DPROM	CHAR	1	0	Final Decision promotion type
71	DDSCP	☐	P10_DDSCP	P10_DDSCP	CHAR	1	0	Final Decision disciplinary action
72	DXRAS	☐	P10_DXRAS	XFELD	CHAR	1	0	Final Decision reassignment flag (Y/N)
73	DXRIN	☐	P10_DXRIN	XFELD	CHAR	1	0	Final Decision reinstatement flag (Y/N)
74	DXRVL	☐	P10_DXRVL	XFELD	CHAR	1	0	Final Decision performance evaluation modified flag (Y/N)
75	DXRMV	☐	P10_DXRMV	XFELD	CHAR	1	0	Final Decision purged of adverse material flag (Y/N)
76	DXOTH	☐	P10_DXOTH	XFELD	CHAR	1	0	Final Decision other corrective action flag (Y/N)
77	DXNOR	☐	P10_DXNOR	XFELD	CHAR	1	0	Final Decision corrective action none required flag (Y/N)
78	DXBCK	☐	P10_DXBCK	XFELD	CHAR	1	0	Final Decision back pay flag (Y/N)
79	DBCKP	☐	P10_DBCKP	P_AMT07V	CURR	13	2	Final Decision back pay amount
80	DXATT	☐	P10_DXATT	XFELD	CHAR	1	0	Final Decision attorney's fees and costs flag (Y/N)
81	DATTN	☐	P10_DATTN	P_AMT07V	CURR	13	2	Final Decision attorney's fee and cost amount
82	DXAWR	☐	P10_DXAWR	XFELD	CHAR	1	0	Final Decision monetary award flag (Y/N)
83	DAWRD	☐	P10_DAWRD	P_AMT07V	CURR	13	2	Final Decision monetary award amount
84	DXSUM	☐	P10_DXSUM	XFELD	CHAR	1	0	Final Decision lump sum flag (Y/N)
85	DLSUM	☐	P10_DLSUM	P_AMT07V	CURR	13	2	Final Decision lump sum amount
86	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0633	BAS01	T5UPBSEEOCBAIS	BAISC
2	PS0633	BAS02	T5UPBSEEOCBAIS	BAISC
3	PS0633	BAS03	T5UPBSEEOCBAIS	BAISC
4	PS0633	BAS04	T5UPBSEEOCBAIS	BAISC
5	PS0633	BAS05	T5UPBSEEOCBAIS	BAISC
6	PS0633	BAS06	T5UPBSEEOCBAIS	BAISC
7	PS0633	BAS07	T5UPBSEEOCBAIS	BAISC
8	PS0633	BAS08	T5UPBSEEOCBAIS	BAISC
9	PS0633	BAS09	T5UPBSEEOCBAIS	BAISC
10	PS0633	BAS10	T5UPBSEEOCBAIS	BAISC
11	PS0633	DACTN	T5UPBSEEOAGAC	DACTN
12	PS0633	DCLSR	T5UPBSEEOCLTP	DCLSR
13	PS0633	ISU01	T5UPBSEEOCBAIS	BAISC
14	PS0633	ISU02	T5UPBSEEOCBAIS	BAISC
15	PS0633	ISU03	T5UPBSEEOCBAIS	BAISC
16	PS0633	ISU04	T5UPBSEEOCBAIS	BAISC
17	PS0633	ISU05	T5UPBSEEOCBAIS	BAISC
18	PS0633	ISU06	T5UPBSEEOCBAIS	BAISC
19	PS0633	ISU07	T5UPBSEEOCBAIS	BAISC
20	PS0633	ISU08	T5UPBSEEOCBAIS	BAISC
21	PS0633	ISU09	T5UPBSEEOCBAIS	BAISC
22	PS0633	ISU10	T5UPBSEEOCBAIS	BAISC
23	PS0633	MTYPE	T5UPBSEEOMTYP	MTYPE

History

Last changed by/on	SAP	20110901
SAP Release Created in	462A