Dictionary > Module Common Data > Table Contract 

TableAbbreviationTitleModuleActivity code
EMPLOCTRCTRContractCommon Data 

KeyDescriptionDuplicatesActivity code
CTR0REFNUM+CTRNUM+CTRDATNo 
CTR1REFNUM+CTRDATYes 
CTR2REFNUM+CTRNUM+NUMLIGYes 
CTR3POTYesKSA

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AEMNUMMEC no. A10   FINTM
AFFMUTCompl. health ins. scheme ADI  [ADI]CODE=329;AFFMUTBlock 
AGNMIDWRKAgency ORG  [ORG]ORG0=AGNMIDWRKBlock 
AUUIDSingle identifier AUUID     
AVNNATBenefits by type A10   FPAY
BUICATCategory C4   FBTP
BUICODASSASSEDIC beneficiary C4   FBTP
BUICODHRSTime type code C4   FBTP
BUICODJOBProfession A10   FBTP
BUICODQLYQualification A10   FBTP
BUICODSALSalary unit C4   FBTP
BUICODTIMWorking hour unit C4   FBTP
BUICOEFactor A10   FBTP
BUIDAYTYPDay type C4   FBTP
BUIGRARank C4   FBTP
BUILEVLevel C4   FBTP
BUIRATEXSReduction rate Expenses C4   FBTP
BUIRETPRVComplementary Retirement & Welfare C4   FBTP
BUISTAPosition C4   FBTP
BUISTAPAYPaying member status C4   FBTP
CALPAYPayroll calculation M15330   
CARTIKRESLunch voucher card C4   FPAY
CATCSPSocio-professional category ADI  [ADI]CODE=362;CATCSPBlock 
CATDEDEmployee cat ded A10   FPAY
CATFRTCategory 2483 ADI  [ADI]CODE=453;CATFRTBlockFRT
CATJOBProfessional status ADI  [ADI]CODE=357;CATJOBBlockPAY
CATQLFQualification code ADI  [ADI]CODE=605;CATQLFBlock 
CCPCCPB member M41   
CDDGRDFixed-term contract reason ADI  [ADI]CODE=356;CDDGRDBlock 
CHEFCTRSupervisors20MAT  [ID]ID0=[CTR]CHEFCTRRTZ 
CLAClauses A200    
CLAAVNSPEClauses of addendum10CLC  [CLC]CLC0=[CTR]CLAAVNSPEBlock 
CLACTRSPEContract clauses10CLC  [CLC]CLC0=[CTR]CLACTRSPEBlock 
CLALETSPEClauses of letter of appointment10CLC  [CLC]CLC0=[CTR]CLALETSPEBlock 
CLEEVETIMTime events balance M41   
CLLCVTCollective agreement ADI  [ADI]CODE=358;CLLCVTBlockPAY
CMTRPLComment5A250    
CODCNBCNBF code C4   FPAY
COECoefficient A9    
CREDATDate created D     
CREDATTIMDate time ADATIM     
CRETIMTime L8    
CREUSRCreation user A5    
CTRCODSEEFederal ID code A10   FPAY
CTRDATDate DTR     
CTRGRDReason ADI  [ADI]CODE=386;CTRGRDBlock 
CTRNUMContract CTR     
DATANCSeniority date D     
DATANCAPTApprentice ref date D     
DATCPYCompany entry date D     
DATFCYSite entry date D     
DATLIBFree date D     
DATLICDate of dismissal D     
DEDAdd. deduction DCB19.8   FPAY
DEGMALSickness delegation M152507  PAY
DETACHESeconded abroad M41  PAY
DNAACTASSLiable for Assedic M42513  PAY
DNAAGSLiable for AGS M152523  PAY
DNACATSPESpecific category ADI  [ADI]CODE=441;DNACATSPEBlockPAY
DNACCPPaid leave fund M42514   
DNACLCClause M41   
DNACODMODWorking conditions M15809   
DNACODTIMWorking time unit M152515   
DNACPYSTGForeign company M42512  PAY
DNAEXOASSUnemployment exemption M152522  PAY
DNARUPCONDate agreement terminated D     
DNASITADMAdmin situation M42511  PAY
DNATYPMODEmployment status M15810   
ENDCONContract end D     
ENDDATSEVEnd date D     
ENDNTC2Notice period end D     
ENDNTC3Notice period end D     
ENDTIMNTCNotice period end D     
ENDTRYTrial end D     
ENDTRY2End 2nd test D     
ENDXITPRVAdvance notice end D     
ETRFCYSite FCY  [FCY]FCY0=ETRFCYBlock 
ETRSRVDepartment SRV  [SRV]SRV0=[CTR]ETRSRVBlock 
ETRTIMArrival time HM     
EVECTRCODContract event15ADI  [ADI]CODE=345;EVECTRCODBlock 
EVECTRDATDate of contract15D     
EXOCOD1Exemption EXO  [EXO]EXO0=EXOCOD1;1BlockPAY
EXOCOD2Exemption EXO  [EXO]EXO0=EXOCOD2;1BlockPAY
EXOCOD3Exemption EXO  [EXO]EXO0=EXOCOD3;1BlockPAY
EXOCOD4Exemption EXO  [EXO]EXO0=EXOCOD4;1BlockPAY
EXOEND1End date D    PAY
EXOEND2End date D    PAY
EXOEND3End date D    PAY
EXOEND4End date D    PAY
EXOSTR1Start date D    PAY
EXOSTR2Start date D    PAY
EXOSTR3Start date D    PAY
EXOSTR4Start date D    PAY
EXSPFLBusiness expenses A10   FPAY
FLGALCCHOUnemp allowances M41   
FLGCREAVNGenerate additional clause M41   
FLGCREBULPayslip break M41  PAY
FLGCRECTRContract generation M41   
FLGCRELETGenerate letter of appointment M41   
FLGDUEExtracted DUE M41   
FLGINDSUPAllowance + stat min M41   
FLGPRVCompleted and paid M41   
FLGPRV2Not completed and paid M41   
FLGPRV3Neither completed nor M41   
FLGRETBackpay M41   
FLGTIMREFHide time references M41  PAY
FLGVARAdditional payments M41   
FLGXITPRVDeparture < advance notice M41   
GRARank A5    
GRDEXUDSNDSN ground for exclusion C4   FPAY
HRSHourly gross DCB5.3   PAY
HRSMTHMonthly hour DCB4.3    
HRSWEKWeekly hour DCB3.3    
INCVARSecondary variable VRA  [VRA]VRA0=[CTR]INCVARBlockPAY
INDIndex A9    
INSAMTUsual prepayment VLR    PAY
INSDAYPrepayment day C2   PAY
JOBPayslip title A30    
JOBPOTStandard job JOT  [JOT]JOT0=[CTR]JOBPOTBlock 
LEVFRTTraining level ADI  [ADI]CODE=347;LEVFRTBlock 
LIEUPlace of show A10   FINTM
LNKLink M41   
LSTDAYLast attend. D     
LVLQLFQualification level A10    
MATREMPReplaces MAT  [ID]ID0=[CTR]MATREMPRTZ 
MODTPSWT smoothing M41  MTT
MTHMonthly gross DCB9.2   PAY
NAFWRKAPE/NAF NAF     
NATCONNature of contract ADI  [ADI]CODE=354;NATCONBlock 
NBRDAYCTRAnnualized no. days DCB3.2    
NBRHOUCTRAnnualized no. hours DCB5.2    
NBRPEO2Children C2    
NBRPEO3Adults C2    
NBRPEO4Others C2    
NBRPERDuration (number) C4    
NBRPSNNumber of services C4   FINTM
NEWTRYTrial renewed M41   
NTFDATNotified on D     
NTICICT C4   FPAY
NUMASSASSEDIC number A10   FPAY
NUMBNFBeneficiary no. A10    
NUMCCPMembership no. ADI  [ADI]CODE=411;NUMCCPBlock 
NUMCONContract no. A20    
NUMLIGNumber C4    
NUMOBJObject number A12    
NUMRGTLedger number L8    
OBJCTRObject of contract A10   FINTM
OBJRUBObjective heading RUB  [RUB]RUB0=[CTR]OBJRUBBlockPAY
OBJVARObjective variable VRA  [VRA]VRA0=[CTR]OBJVARBlockPAY
OPEDEDDeduction option C4   FPAY
ORGMALHealth ins. body A30    
PERCONContract period M15313   
PLNTYPReference planning PLN     
POTPosition POT  [POT]POT0=POTBlock 
PROPRFProfile PRF  [PRF]PRF0=[CTR]PROPRFBlock 
PRUACVIndustrial tribunal M15353   
PRUCOLIndustrial tribunal M15352   
PRUCTRIndustrial tribunal M15382   
PRUVOTIndustrial tribunal M15354   
PSNJOBJob ADI  [ADI]CODE=604;PSNJOBBlock 
PSNTYPType of service C4   FINTM
QLFQualification A30    
RATMIDWRKPT rate RAT     
RAZCUMRTZ of totals M41  PAY
REFCAECEA reference A10    
REFNUMEmployee ID MAT  [ID]ID0=[CTR]REFNUMDelete 
RETCTRDATORIOriginal contract date D     
RETCTRNUMORIOriginal contract number VCR     
RETDATEFFBack-pay effective date D     
RETGRDReason for back-pay ADI  [ADI]CODE=443;RETGRDBlock 
RETSTATUTBack-pay status M15645   
RETTYPBack-pay type M20644   
ROWOBJRUBSequence C4   PAY
RPLSubstitute5MAT  [ID]ID0=RPLRTZ 
RPTBULPayslip ARP  [ARP]ARP0=RPTBULBlockPAY
RSKWRKRisk VAC  [WAC]WAC0=[CTR]RSKWRKBlockPAY
SALETPPTW salary DCB9.2    
SCHJOBStudent M41   
SEVCTRMultiple jobs M42407   
SEVEMPMultiple employers M42407   
STABEFETRSituation before hiring M152403   
STACATCategroy ADI  [ADI]CODE=364;STACATBlockPAY
STACAT2Category status ADI  [ADI]CODE=368;STACAT2Block 
STACTRContract status C4   FINTM
STAEMPExecutive status M15306   
STRCAECEA start D     
STRDATSEVStart date D     
STRNTC2Notice period start D     
STRNTC3Notice period start D     
STRTIMNTCNotice period start D     
STRXITPRVAdvance notice start D     
SUICARCareer follow-up M41   
SYSATWI scheme ADI  [ADI]CODE=355;SYSATBlockPAY
SYSFLGSS scheme extension C4   FPAY
SYSMALSickness scheme ADI  [ADI]CODE=355;SYSMALBlockPAY
SYSSSCBasic scheme ADI  [ADI]CODE=355;SYSSSCBlockPAY
SYSVIPOld age scheme Employer's contribution ADI  [ADI]CODE=355;SYSVIPBlockPAY
SYSVISOld age scheme Employee's contribution ADI  [ADI]CODE=355;SYSVISBlockPAY
TIPTip C4   FPAY
TWDPAYNet to gross payroll M41  PAY
TYPCACFee type C4   FINTM
TYPJOBJob type M15312   
TYPLNKKinship M302524   
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDTIMTime L8    
UPDUSRChange user A5    
WAGPAYPERSalary periodicity M15801   
WRKADD1Address ADL     
WRKADD2Address ADL     
WRKADD3Address ADL     
WRKCODPOSPostal code POS     
WRKCODSEEMunicipality code A5    
WRKCRNSite tax ID number CRT     
WRKCRYCountry CRY  [TCY]TCY0=[CTR]WRKCRYBlock 
WRKCRYNAMCountry name NCY     
WRKCTYCity CTY     
WRKFLGADDSite M41   
WRKNAMWorkplace name A30    
WRKNATLEGLegal nature C4   FPAY
WRKSTGWork abroad M15317  PAY
XITDATIssue date D     
XITFNLFinal exit M41   
XITGRDReasons ADI  [ADI]CODE=359;XITGRDBlock 
XITLEADeparture for leave ADI  [ADI]CODE=379;XITLEABlock 
ZON1Free field DCB9.2    
ZON2Free field DCB9.2