PAPBSMXSARC - SAR current result

SAR current result information is stored in SAP table PAPBSMXSARC.
It is part of development package P32P1 in software component PY-MX-PS. This development package consists of objects that can be grouped under "Public Sector ISSSTE development for Mexico".

Fields for table PAPBSMXSARC

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
.INCLUDEKEYXPMXP_SARDKEY0
PERNRPersonnel NumberXPERSNONUMC16PA0003
RPTYRReport yearXPMXP_RPTYRNUMC8
RPTPDReport periodXPMXP_RPTPDNUMC4
.INCLUDEDETAILPMXP_SARDTL0
EVTYPEvent typePMXP_EVTYPCHAR2
RFCNPRFC NumberPMXP_RFCNMCHAR26
RFCNCRFC NumberPMXP_RFCNMCHAR26
CURPPCURP numberPMXP_CURPNCHAR36
CURPCCURP numberPMXP_CURPNCHAR36
SSNNPIMSS affiliation numberPMX_NIMSSCHAR22
SSNNCIMSS affiliation numberPMX_NIMSSCHAR22
LNAMPLast NamePAD_NACHNCHAR80
LNAMCLast NamePAD_NACHNCHAR80
SNAMPSecond NamePAD_NACH2CHAR80
SNAMCSecond NamePAD_NACH2CHAR80
FNAMPFirst NamePAD_VORNACHAR80
FNAMCFirst NamePAD_VORNACHAR80
PATNPISSSTE paying agent numberPMXP_PATNRCHAR12
PATNCISSSTE paying agent numberPMXP_PATNRCHAR12
WKCTPDistribution keyPMXP_WKCTRCHAR40
WKCTCDistribution keyPMXP_WKCTRCHAR40
BRANNISSSTE actual branch codePMXP_BRANNCHAR10
PAYCTPayment center IDPMXP_PAYCTCHAR14
ICEFABank codePMXP_ICEFACHAR6
GBDATDate of BirthGBDATDATS16
GBDEPBirth state codePMXP_GBDEPCHAR4
GESCHGender keyPMXP_GESCHCHAR2
BEGDAStart DateBEGDADATS16
CONDAISSSTE contribution start datePMXP_CONDADATS16
TEMDAEnd DateENDDADATS16
BQWAMBQW amountPMXP_BQWAMCURR8
FOVLNFOVISSSTE loan indicatorPMXP_FOVLNCHAR2
SARAMSAR contribution amountPMXP_SARAMCURR8
SARAASAR addtional contribtuion amountPMXP_SARAACURR8
SARITSAR interest for late submissionPMXP_SARITCURR8
FOVAMFOVISSSTE contribution amountPMXP_FOVAMCURR8
FOVAAFOVISSSTE additional contribution amountPMXP_FOVAACURR8
FOVITFOVISSSTE interest for late submissionPMXP_FOVITCURR8
WAERSCurrency KeyWAERSCUKY10*
MARSTMarital Status KeyFAMSTCHAR2*
EEADRStreet and House NumberPAD_STRASCHAR120
EEDSTLocality or district of workerPMXP_EEDSTCHAR60
EECTYCity, locality or municipality of the workerPMXP_EECTYCHAR60
EEZIPEmployee's postal codePMXP_EEZIPCHAR10
EESTEFederal area of workerPMXP_EESTECHAR4
APPTYEmployee's appointment typePMXP_APPTYCHAR4
INTCNWorker internal control numberPMXP_INTCNCHAR60
SCDATSalary change datePMXP_SCDATDATS16
ISBQWSalario Base de Cotizaci�n ISSSTEPMXP_ISBQWCURR8
SABQWSAR Basic Quotation WagePMXP_SABQWCURR8
INTWGIntegrated wagePMXP_INTWGCURR8
WKDAYDays worked in the period (bimonthly)PMXP_WKDAYDEC8
MARSPMarital Status KeyFAMSTCHAR2*
EEADPStreet and House NumberPAD_STRASCHAR120
EEDSPLocality or district of workerPMXP_EEDSTCHAR60
EECTPCity, locality or municipality of the workerPMXP_EECTYCHAR60
EEZPPEmployee's postal codePMXP_EEZIPCHAR10
EESTPFederal area of workerPMXP_EESTECHAR4
APPTPEmployee's appointment typePMXP_APPTYCHAR4
ICEFPBank codePMXP_ICEFACHAR6
INTCPWorker internal control numberPMXP_INTCNCHAR60
SCDAPSalary change datePMXP_SCDATDATS16
ISBQPSalario Base de Cotizaci�n ISSSTEPMXP_ISBQWCURR8
SABQPSAR Basic Quotation WagePMXP_SABQWCURR8
INTWPIntegrated wagePMXP_INTWGCURR8
WKDAPDays worked in the period (bimonthly)PMXP_WKDAYDEC8
TMRSNCause of deregistrationPMXP_TMRSNCHAR2
PERNPPersonnel NumberPERSNONUMC16*
DINCADays worked in the period (bimonthly)PMXP_WKDAYDEC8
DINCPDays worked in the period (bimonthly)PMXP_WKDAYDEC8
DAUSEDays worked in the period (bimonthly)PMXP_WKDAYDEC8
DAUSPDays worked in the period (bimonthly)PMXP_WKDAYDEC8
AFOREEvent typePMXP_EVTYPCHAR2
AFORPEvent typePMXP_EVTYPCHAR2
AHSOLSingle-Character FlagCHAR1CHAR2
AHSOPSingle-Character FlagCHAR1CHAR2
IAHSCCurrent solidary savings amountPMXP_IAHSCCURR8
IAHSPAmount of previous solidary savingsPMXP_IAHSPCURR8
Privacy Policy