SAP Table RCF_S_AUDIT_TRAIL

Audit Trail for Candidate's Resume

RCF_S_AUDIT_TRAIL (Audit Trail for Candidate's Resume) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RCF_S_AUDIT_TRAIL to other SAP tables.

RCF_S_AUDIT_TRAIL table fields

Field Data element Checktable Datatype Length Decimals
VERSION Version HRKWF_VERSION NUMC 6 0
LANGUAGE Language Key SPRAS LANG 1 0
CREATED_AT_DATE Date of Creation (Audit Trail) RCF_CREATED_AT_DATE_AUDIT DATS 8 0
CREATED_AT_TIME Date of Creation (Audit Trail) RCF_CREATED_AT_TIME_AUDIT TIMS 6 0
CREATED_BY Creator (Audit Trail) RCF_CREATED_BY_AUDIT CHAR 12 0
AEDTM Change Date of Candidate's Resume (Audit Trail) RCF_AEDTM_AUDIT DATS 8 0
EMPLOYEEID Personnel Number PERNR_D NUMC 8 0
BUSINESSPARTNER Business Partner Number BU_PARTNER CHAR 10 0
PERSONNUMBER Person number AD_PERSNUM CHAR 10 0
HROBJECT HROBJECT STRU 0 0
PLVAR Plan Version PLVAR CHAR 2 0
OTYPE Object Type OTYPE CHAR 2 0
OBJID Object ID OBJEKTID NUMC 8 0
CAND_INFO RCF_S_CAND_INFO_AUDIT STRU 0 0
MANDT Client MANDT CLNT 3 0
PLVAR Plan Version PLVAR CHAR 2 0
OTYPE Object Type OTYPE CHAR 2 0
OBJID Object ID OBJEKTID NUMC 8 0
INFTY Infotype INFOTYP CHAR 4 0
SUBTY Subtype SUBTYP CHAR 4 0
ISTAT Planning Status ISTAT_D CHAR 1 0
PRIOX Priority PRIOX CHAR 2 0
BEGDA Start Date BEGDATUM DATS 8 0
ENDDA End Date ENDDATUM DATS 8 0
VARYF Variation Field for File PLOG VARYF CHAR 10 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed on AEDTM DATS 8 0
UNAME User Name USRNAME CHAR 12 0
REASN Reason REASN CHAR 2 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
STATUS Candidate Status RCF_CAND_STATUS NUMC 1 0
0 Locked
1 Released
2 Released
SELF_DESCRIPTION Candidate's Self-Description (Pointer) RCF_CAND_SELF_DESC NUMC 6 0
EXP_ABROAD Candidate's Experience Abroad (Pointer) RCF_CAND_EXP_ABROAD NUMC 6 0
HOMEPAGE Homepage of Candidate RCF_CANDIDATE_HOMEPAGE CHAR 200 0
TGROUP Interest Group RCF_TARGET_GRP NUMC 4 0
DEREGISTERED Registration of Candidate Deleted RCF_CAND_DEREGISTERED CHAR 1 0
X TRUE
NULL FALSE
PRIVACY_STATUS Data Privacy Statement Accepted RCF_PRIVACY_STATEMENT CHAR 1 0
X Privacy Statement Accepted Through Registration
U Privacy Statement Accepted Through Unregistered Application
P Privacy Statement Accepted Through Passive Registration
CLASSIFICATION Candidate Ranking RCF_CAND_CLASSIFICATION DEC 5 2
IS_INACTIVE Inactive Employee RCF_EMPLOYEE_INACTIVE CHAR 1 0
X TRUE
NULL FALSE
IS_CLASSIFIED Candidate has been Ranked RCF_CAND_IS_CLASSIFIED CHAR 1 0
X TRUE
NULL FALSE
LAST_UPDATED_BY User Name USRNAME CHAR 12 0
LAST_UPDATED_ON Date DATUM DATS 8 0
VERIFICATION Status of E-Mail Verification RCF_VERIFICATION_STATUS NUMC 1 0
0 Confirmed
1 Outstanding
2 Not Confirmed
ATTEMPTS Number of Attempts RCF_NO_ATTEMPTS NUMC 4 0
ATTEMPTED_ON Time of Last Attempt RCF_LAST_ATTEMPT_TIME DEC 15 0
E_MAIL E-Mail Address AD_SMTPADR CHAR 241 0
STATUS_TXT Explanatory short text DDTEXT CHAR 60 0
TGROUP_TXT Description of Interest Group RCF_TARGET_GRP_TXT CHAR 40 0
CLASSIFICATION_TXT Object Name STEXT CHAR 40 0
SELF_DESCRIPTION_DESC Transfer Object for Free Texts from Infotypes RCF_ITF_DESCRIPTION STRG 0 0
EXP_ABROAD_DESC Transfer Object for Free Texts from Infotypes RCF_ITF_DESCRIPTION STRG 0 0
CENTRALDATAPERSON RCF_S_CENTRALDATAPERSON_AUDIT STRU 0 0
FIRSTNAME First name of business partner (person) BU_NAMEP_F CHAR 40 0
LASTNAME Last name of business partner (person) BU_NAMEP_L CHAR 40 0
BIRTHNAME Name at birth of business partner BU_BIRTHNM CHAR 40 0
MIDDLENAME Middle name or second forename of a person BU_NAMEMID CHAR 40 0
SECONDNAME Other Last Name of a Person BU_NAMEPL2 CHAR 40 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 CHAR 4 0
TITLE_ACA2 Second academic title (key) AD_TITLE2 CHAR 4 0
TITLE_SPPL Name supplement, e.g. noble title (key) AD_TITLES CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX CHAR 4 0
PREFIX2 2nd name prefix (key) AD_PREFIX2 CHAR 4 0
NICKNAME Nickname of Business Partner (Person) BU_NICKNAM CHAR 40 0
INITIALS "Middle Initial" or personal initials AD_INITS CHAR 10 0
NAMEFORMAT Name format AD_FORMAT CHAR 2 0
NAMCOUNTRY Country for name format rule AD_NAMCTRY CHAR 3 0
NAMCOUNTRYISO Country ISO code INTCA CHAR 2 0
SEX Sex of business partner (person) BU_SEXID CHAR 1 0
NULL Unknown
1 Female
2 Male
BIRTHPLACE Birthplace of business partner BU_BIRTHPL CHAR 40 0
BIRTHDATE Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
DEATHDATE Date of death of business partner BU_DEATHDT DATS 8 0
MARITALSTATUS Marital Status of Business Partner BU_MARST CHAR 1 0
CORRESPONDLANGUAGE Business Partner: Correspondence Language BU_LANGU_CORR LANG 1 0
CORRESPONDLANGUAGEISO 2-Character SAP Language Code LAISO CHAR 2 0
FULLNAME Full Name BU_NAME1TX CHAR 80 0
EMPLOYER Name of Employer of a Natural Person BU_EMPLO CHAR 35 0
OCCUPATION Occupation/group BU_JOBGR CHAR 4 0
NATIONALITY Nationality BU_NATIO CHAR 3 0
NATIONALITYISO Country ISO code INTCA CHAR 2 0
COUNTRYORIGIN Ctry of Origin: Non-Res. Companies BU_CNDSC CHAR 3 0
TITLE_ACA1_TXT Academic title description AD_TITLE1D CHAR 40 0
SEX_TXT Explanatory short text DDTEXT CHAR 60 0
CENTRALDATA RCF_S_CENTRALDATA_AUDIT STRU 0 0
SEARCHTERM1 Search term 1 for business partner BU_SORT1 CHAR 20 0
SEARCHTERM2 Search term 2 for business partner BU_SORT2 CHAR 20 0
PARTNERTYPE Business Partner Type BU_BPKIND CHAR 4 0
AUTHORIZATIONGROUP Authorization Group BU_AUGRP CHAR 4 0
PARTNERLANGUAGE Business partner: Language BU_LANGU LANG 1 0
PARTNERLANGUAGEISO 2-Character SAP Language Code LAISO CHAR 2 0
DATAORIGINTYPE Data Origin Types BU_SOURCE CHAR 4 0
CENTRALARCHIVINGFLAG Central Archiving Flag BU_XDELE CHAR 1 0
X Yes
NULL No
CENTRALBLOCK Central Block for Business Partner BU_XBLCK CHAR 1 0
X Yes
NULL No
TITLE_KEY Form-of-Address Key AD_TITLE CHAR 4 0
CONTACTALLOWANCE Business Partner: Contact Permission BU_CONTACT CHAR 1 0
1 Allowed
2 Disallowed
3 Check Permission
PARTNEREXTERNAL Business Partner Number in External System BU_BPEXT CHAR 20 0
TITLELETTER Salutation BU_TITLE_LET CHAR 50 0
NOTRELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1 0
X Yes
NULL No
COMM_TYPE Communication Method (Key) (Business Address Services) AD_COMM CHAR 3 0
PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1 0
1 Braille
2 Large Print
TITLE_TXT Title text AD_TITLETX CHAR 30 0
ADDRESSDATA RCF_T_ADDRESSDATA_AUDIT TTYP 0 0
TELEPHONEDATA RCF_T_TELEPHONEDATA_AUDIT TTYP 0 0
FAXDATA RCF_T_FAXDATA_AUDIT TTYP 0 0
EMAILDATA RCF_T_EMAILDATA_AUDIT TTYP 0 0
WORKEXPERIENCE RCF_T_WORKEXPERIENCE_AUDIT TTYP 0 0
EDUCATION RCF_T_EDUCATION_AUDIT TTYP 0 0
QUALIFICATIONS RCF_T_QUALIFICATIONS_AUDIT TTYP 0 0
ATTACHMENTS RCF_T_ATTACHMENTS_TEXT TTYP 0 0