SAP table PS0465 (HR master record infotype 0465 (Documents))

Field Description Data Type Length Decimals Checktable Data Element
TPDOC Document Type CHAR 4 0 T591A TPDOC
DT_EMIS Document's Issue Date DATS 8 0 PBR_DEMIS
ES_EMIS State (FU) CHAR 3 0 PBR_ESTAD
AC Acre
AL Alagoas
AM Amazonas
AP Amapá
BA Bahia
CE Ceará
DF Distrito Federal
ES Espírito Santo
GO Goiás
MA Maranhão
MG Minas Gerais
MS Mato Grosso do Sul
MT Mato Grosso
PA Pará
PB Paraíba
PE Pernambuco
PI Piauí
PR Paraná
RJ Rio de Janeiro
RN Rio Grande do Norte
RO Rondônia
RR Roraima
RS Rio Grande do Sul
SC Santa Catarina
SE Sergipe
SP São Paulo
TO Tocantins
ZZ Foreign
CPF_NR Sole Proprietor's Registry number (CPF) CHAR 15 0 PBR_CPFNR
IDENT_NR Identification Document number CHAR 16 0 PBR_IDNR
IDENT_ORG Identification Document Issuer CHAR 8 0 PBR_IDORG
CTPS_NR Worker's Card for Social Welfare number - WCSW CHAR 10 0 PBR_CTNR
CTPS_SERIE Worker's Card series number - WCSW CHAR 6 0 PBR_CTSR
CREG_NR Regional Council register number CHAR 15 0 PBR_CRNR
CREG_NAME Regional Council name CHAR 90 0 PBR_CRNAM
CREG_INIT Regional Council abbreviation CHAR 10 0 PBR_CRIN
ELEC_NR Voter Registration Card number CHAR 15 0 PBR_ELECN
ELEC_ZONE Voter Registration Card area CHAR 5 0 PBR_ELECZ
ELEC_SECT Voting Section CHAR 5 0 PBR_ELECS
PIS_NR SIP/PSHFP number CHAR 20 0 PBR_PSNR
MIL_NR Military Certificate number CHAR 12 0 PBR_MILNR
MIL_TYPE Military Certificate type CHAR 8 0 PBR_MILTY
MIL_CAT Military Certificate category CHAR 3 0 PBR_MILCA
IDFOR_NR Foreign Identification Document number CHAR 20 0 PBR_IDFNR
VISA_NR Visa series number CHAR 6 0 PBR_VISNR
VISA_TYPE Type of Visa CHAR 20 0 PBR_VISTY
MARRY_BR Brazilian spouse CHAR 1 0 PBR_MARBR
DT_ARRV Date of arrival in Brazil DATS 8 0 PBR_DTARR
DRIVE_NR Professional Driver's License number CHAR 12 0 PBR_DRVNR
DRIVE_CAT Driver's License category CHAR 3 0 PBR_DRVCT
Not reported
A Driver of two and three-wheel motorised vehicles
AB Combination of category A and B
AC Combination of category A and C
AD Combination of category A and D
AE Combination of category A and E
B Driver of motorised vehicle not covered by category A
C Driver of motorised vehicle used for freight transport
D Driver of motorised vehicle used for passenger transport
E Driver of vehicle combination
PASSP_NR Passport number CHAR 15 0 PBR_PASNR
NIT_NR Employee Identification Number - EIN CHAR 11 0 PBR_NITNR
CARTO Name of public notary CHAR 40 0 PBR_CARTO
CDEAT Death certificate CHAR 10 0 PBR_CDEAT
DEATH Date of death notification DATS 8 0 PBR_DEATH
CAUDE Cause of death CHAR 1 0 PBR_CAUDE
1 Natural
2 Non-natural
CHILDBR Brazilian children indicator CHAR 1 0 HRPADBR_BRAZIL_CHILD
DOC_ISSUER Document issuing authority CHAR 20 0 HRPADBR_DOC_ISSUER
DOC_NR Document number CHAR 40 0 HRPADBR_DOC_NR
FOREIGN_SIT Classification of foreign employee condition in Brazil CHAR 2 0 HRPADBR_FOREIGN_SITUATION
01 Permanent visa
02 Temporary visa
03 Asylum-seeker
04 Refugee
05 Refugee seeker
06 Resident outside Brazil
07 Physically disabled and over 51 years old
08 With temporary residence and amnestied, irregular situation
09 Stay in Brazil due to children or Brazilian spouse
10 Benefited by Mercosul countries agreement
11 Dependent diplom.and/or consular agent countries recipr.conv
12 Benefited by Treaty friendship, cooper.and consul.w/Portugal
13 Stay in Brazil due to family reunion
RESID_TIME_TYPE Residence time of immigrant worker CHAR 1 0 HRPADBR_RESIDENCE_TIME_TYPE
1 Indefinite term
2 Fixed term

PS0465 foreign key relationships

Table Field Check Table Check Field
0 PS0465 TPDOC T591A Subtype Characteristics MANDT
0 PS0465 TPDOC T591A Subtype Characteristics INFTY
0 PS0465 TPDOC T591A Subtype Characteristics SUBTY