T7BREFD_CATCERT - Medical certificate

Medical certificate information is stored in SAP table T7BREFD_CATCERT.
It is part of development package PB37 in software component PA-PA-BR. This development package consists of objects that can be grouped under "HR master data: Brazil".

Fields for table T7BREFD_CATCERT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		HRPADBR_EFD_S_APP_KEY_FIELDS	0
MANDT	Client	X	MANDT	CLNT	6	T000
EVENT_ID	Event identifier	X	HRPADBR_EFD_EVENT_ID	NUMC	40	T7BREFD_EVENT
RECORD_ID	Record code	X	HRPADBR_EFD_RECORD_ID	NUMC	18
.INCLUDE				HRPADBR_EFD_S_APP_OTHER_FIELDS	0
PARENT_ID	Parent record code		HRPADBR_EFD_PARENT_ID	NUMC	18
CNES	Unit code national registration health establishments (CNES)			CHAR	14
APPOINT_DATE	Treatment date		HRPADBR_EFD_TREATMENT_DATE	DATS	16
APPOINT_TIME	Treatment hour		HRPADBR_EFD_TREATMENT_TIME	CHAR	8
IND_HOSP	Referral indicator		HRPADBR_EFD_IND_HOSP	CHAR	2
APPOINT_DURATION	Treatment estimated duration		HRPABDR_EFD_TREATMENT_DURATION	NUMC	8
ABSENCE_IND	Absence indicator		HRPADBR_EFD_IND_ABSENCE	CHAR	2
INJURY_DESC	Injury nature description		HRPADBR_EFD_INJURY_DESC	NUMC	18
INJURY_COMP_DESC	Injury additional description		HRPADBR_EFD_INJURY_DESC_FULL	CHAR	400
LIKELI_DIAGN	Likely diagnosis		HRPABDR_EFD_LIKELI_DIAGN_IND	CHAR	200
COD_CID	International Statist.Classif.Diseases code		HRPADBR_EFD_COD_CID	CHAR	10
OBSERVATION	Observation		HRPADBR_EFD_OBSERVATION	CHAR	510
DOCTOR_NAME	Physician name		HRPADBR_DOCTOR_NAME	CHAR	160
OC	Class body		HRPADBR_EFD_OC	NUMC	2
NR_OC	Registration number in the class body		HRPADBR_EFD_OC_NR	CHAR	28
UF_OC	Region (State, Province, County)		REGIO	CHAR	6