T7BR_UNINEE

Application record - unemployment insurance | #transactional | Component: Brazil
Column Name Description
MANDT FK Client
EVENT_ID FK Event identifier
RECORD_ID Record code
Column Name Description
Column Name Description
Column Name Description
Column Name Description
GENDER Gender Key Show values
PAID_NOTICE Tipe of notice period Show values
Column Name Description Domain name
PARENT_ID Parent record code NUMC09
RECORD_TYPE Record type CHAR2
CPF Registration number in the CPF NUMC11
NAME Employee name CHAR40
ADDRESS Employee address CHAR40
ADDRESS_COMPL Address affix CHAR16
ZIP_CODE Postal Code NUMC08
UF State CHAR2
DDD DDD NUMC02
PHONE Telephone no. NUMC08
MOTHER_NAME Mother's name CHAR40
PIS PIS CHAR11
CTPS_NR null
CTPS_SERIE null
CTPS_UF WCSW state CHAR2
CBO Brazilian Job Occupation Code NUMC6
HIRING_DATE Hiring date CHAR8
FIRING_DATE Dismissal date CHAR8
SCHOOL_GRADE Education level PBR_FASAR
BIRTH_DATE Birth date CHAR8
WORKED_HOURS Working hours NUMC02
ANTEPEN_SALARY Third-last salary NUMC10
PENULT_SALARY Penultimate salary NUMC10
LAST_SALARY Last salary NUMC10
WORKED_MONTHS Number of worked months NUMC02
LAST_6_SALARIES Receipt of the last 6 salaries NUMC01
BANK_CODE Bank code NUMC03
BANK_AGENCY Branch bank code NUMC04
VC_AGENCY Bank branch check digit NUMC01
CTPS_NUM WCSW number CHAR8
CTPS_SER WCSW series CHAR5
Master Data Relations Join Conditions
Event identifier
Client T7BR_UNINEE.MANDT == T000.MANDT