r5fbldataloadercolumnsv8
DESCRIPTION
R5FBLDataLoaderColumnsV8TRANSCRIPT
ColumnsBusinessObjectVO NameVO Attribute NameDatastore Attribute NameStage Column NameColumn TypeColumn ReferenceSQL TypePrimary KeyLengthScaleMandatoryCommentActionReasonsActionReasonsVOActionReasonIdACTION_REASON_IDPVAL001Primary keyIdUSRKEYYes180YesActionReasonsActionReasonsVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userActionReasonsActionReasonsVOActionReasonCodeACTION_REASON_CODEPVAL003VARCHARNo30YesAction Reason CodeActionReasonsActionReasonsVOActionReasonACTION_REASONPVAL004VARCHARNo80YesAction ReasonActionReasonsActionReasonsVOStartDateSTART_DATEPVAL005DATENoYesStart DateActionReasonsActionReasonsVOEndDateEND_DATEPVAl006DATENoNoEnd DateActionsActionsVOActionIdACTION_IDPVAL001Primary keyIdUSRKEYYes180YesActionsActionsVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userActionsActionsVOActionCodeACTION_CODEPVAL003VARCHARNo30YesAction CodeActionsActionsVODescriptionDESCRIPTIONPVAL004VARCHARNo4000NoDescriptionActionsActionsVOActionNameACTION_NAMEPVAL005VARCHARNo320YesAction NameActionsActionsVOStartDateSTART_DATEPDATE001DATENo7YesStart DateActionsActionsVOEndDateEND_DATEPDATE002DATENo7NoEnd DateActionsActionsVOActionTypeIdACTION_TYPE_IDPVAL006Table LookupPER_ACTION_TYPES_B.ACTION_TYPE_IDNUMERICNo180YesValidated against PER_ACTION_TYPES_B.ACTION_TYPE_IDActionsActionReasonUsagesVOActionReasonUsageIdACTION_REASON_USAGE_IDPVAL001Primary keyIdUSRKEYYes18YesPrimary key - use unique identifier of objectActionsActionReasonUsagesVOActionIdACTION_IDPVAL002Foreign KeyIdACTIONS_VO.ACTION_IDNUMERICNo180YesReference value used to identify Action (ActionId in ActionsVO object)
ActionsActionReasonUsagesVOActionReasonIdACTION_REASON_IDPVAL003Foreign KeyIdACTION_REASONS_VO.ACTION_REASON_IDNUMERICNo180YesReference value used to identify Action Reason (ActionReasonId in ActionReasonsVO object)
ActionsActionReasonUsagesVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userActionsActionReasonUsagesVOStartDateSTART_DATEPDATE001DATENoYesStart DateActionsActionReasonUsagesVOEndDateEND_DATEPDATE002DATENoNoEnd DateBusinessUnitBusinessUnitVOBusinessUnitIdORGANIZATION_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectBusinessUnitBusinessUnitVOEnterpriseIdBUSINESS_GROUP_IDPVAL002NUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userBusinessUnitBusinessUnitVONameNAMEPVAL003VARCHARNo2400YesUnique NameBusinessUnitBusinessUnitVOShortCodeORG_INFORMATION5PVAL004VARCHARNo1500NoLeave blankBusinessUnitBusinessUnitVOStatusSTATUSPVAL005VARCHARNo300NoA or I (Active or Inactive)BusinessUnitBusinessUnitVOLocationIdLOCATION_IDPVAL006NUMERICNo180NoLeave blankBusinessUnitBusinessUnitVOManagerIdORG_INFORMATION1PVAL007VARCHARNo1500NoLeave blankBusinessUnitBusinessUnitVOLegalEntityIdORG_INFORMATION2PVAL008VARCHARNo1500NoLeave blankBusinessUnitBusinessUnitVOPrimaryLedgerIdORG_INFORMATION3PVAL009VARCHARNo1500NoLeave blankBusinessUnitBusinessUnitVODefaultSetIdORG_INFORMATION4PVAL010USRKEYNo360YesThe GUID reference to the Set extracted from Fusion that will be the business unit's default set assignmentBusinessUnitBusinessUnitVOEnabledForHRFlagORG_INFORMATION6PVAL011VARCHARNo1500YesYBusinessUnitBusinessUnitVOFinancialsBusinessUnitIdORG_INFORMATION7PVAL012VARCHARNo1500NoLeave blankBusinessUnitBusinessUnitVODefaultCurrencyCodeORG_INFORMATION8PVAL013VARCHARNo1500NoLeave blankBusinessUnitBusinessUnitVOClassificationCLASSIFICATION_CODEPVAL014VARCHARNo400NoLeave blankBusinessUnitBusinessUnitVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)BusinessUnitBusinessUnitVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)BusinessUnitBusinessUnitVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateBusinessUnitBusinessUnitVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateContentItemContentItemVOContentItemIdCONTENT_ITEM_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectContentItemContentItemVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICYes360YesLeave blank - it will be set to the Enterprise of the invoking userContentItemContentItemVOContentTypeIdCONTENT_TYPE_IDPVAL003USRKEYNo360YesReference value used to identify Content Type (ContentTypeID in ContentTypeVO object)ContentItemContentItemVOContentItemCodeCONTENT_ITEM_CODEPVAL004VARCHARNo300NoContentItemContentItemVONameNAMEPVAL005VARCHARNo7000YesContentItemContentItemVOItemDescriptionITEM_DESCRIPTIONPVAL006VARCHARNo20000NoContentItemContentItemVODateFromDATE_FROMPDATE001DATENo00YesContentItemContentItemVODateToDATE_TOPDATE002DATENo00NoContentItemContentItemVORatingModelIdRATING_MODEL_IDPVAL007USRKEYNo360NoReference value used to identify Rating Model (RatingModelID in RatingModelVO object)ContentItemContentItemVOCountryIdCOUNTRY_IDPVAL008NUMERICNo180NoContentItemContentItemVOContentSupplierCodeCONTENT_SUPPLIER_CODEPVAL009VARCHARNo300NoContentItemContentItemVOContentKeyflexIdCONTENT_KEYFLEX_IDPVAL010NUMERICNo180NoContentItemContentItemVOItemTextTl1ITEM_TEXT_TL_1PVAL011VARCHARNo2400NoContentItemContentItemVOItemTextTl2ITEM_TEXT_TL_2PVAL012VARCHARNo2400NoContentItemContentItemVOItemTextTl3ITEM_TEXT_TL_3PVAL013VARCHARNo2400NoContentItemContentItemVOItemTextTl4ITEM_TEXT_TL_4PVAL014VARCHARNo2400NoContentItemContentItemVOItemTextTl5ITEM_TEXT_TL_5PVAL015VARCHARNo2400NoContentItemContentItemVOItemTextTl6ITEM_TEXT_TL_6PVAL016VARCHARNo20000NoContentItemContentItemVOItemTextTl7ITEM_TEXT_TL_7PVAL017VARCHARNo20000NoContentItemContentItemVOItemTextTl8ITEM_TEXT_TL_8PVAL018VARCHARNo20000NoContentItemContentItemVOItemTextTl9ITEM_TEXT_TL_9PVAL019VARCHARNo20000NoContentItemContentItemVOItemTextTl10ITEM_TEXT_TL_10PVAL020VARCHARNo20000NoContentItemContentItemVOItemTextTl11ITEM_TEXT_TL_11PVAL021VARCHARNo40000NoContentItemContentItemVOItemTextTl12ITEM_TEXT_TL_12PVAL022VARCHARNo40000NoContentItemContentItemVOItemTextTl13ITEM_TEXT_TL_13PVAL023VARCHARNo40000NoContentItemContentItemVOItemTextTl14ITEM_TEXT_TL_14PVAL024VARCHARNo40000NoContentItemContentItemVOItemTextTl15ITEM_TEXT_TL_15PVAL025VARCHARNo40000NoContentItemContentItemVOItemDescrlongITEM_DESCRLONGPVAL026VARCHARNo40000NoContentItemContentItemVOItemNumber1ITEM_NUMBER_1PVAL027NUMERICNo180NoContentItemContentItemVOItemNumber2ITEM_NUMBER_2PVAL028NUMERICNo180NoContentItemContentItemVOItemNumber3ITEM_NUMBER_3PVAL029NUMERICNo180NoContentItemContentItemVOItemNumber4ITEM_NUMBER_4PVAL030NUMERICNo180NoContentItemContentItemVOItemNumber5ITEM_NUMBER_5PVAL031NUMERICNo180NoContentItemContentItemVOItemNumber6ITEM_NUMBER_6PVAL032NUMERICNo180NoContentItemContentItemVOItemNumber7ITEM_NUMBER_7PVAL033NUMERICNo180NoContentItemContentItemVOItemNumber8ITEM_NUMBER_8PVAL034NUMERICNo180NoContentItemContentItemVOItemNumber9ITEM_NUMBER_9PVAL035NUMERICNo180NoContentItemContentItemVOItemNumber10ITEM_NUMBER_10PVAL036NUMERICNo180NoContentItemContentItemVOItemDate1ITEM_DATE_1PDATE003DATENo00NoContentItemContentItemVOItemDate2ITEM_DATE_2PDATE004DATENo00NoContentItemContentItemVOItemDate3ITEM_DATE_3PDATE005DATENo00NoContentItemContentItemVOItemDate4ITEM_DATE_4PDATE006DATENo00NoContentItemContentItemVOItemDate5ITEM_DATE_5PDATE007DATENo00NoContentItemContentItemVOItemDate6ITEM_DATE_6PDATE008DATENo00NoContentItemContentItemVOItemDate7ITEM_DATE_7PDATE009DATENo00NoContentItemContentItemVOItemDate8ITEM_DATE_8PDATE010DATENo00NoContentItemContentItemVOItemDate9ITEM_DATE_9PDATE011DATENo00NoContentItemContentItemVOItemDate10ITEM_DATE_10PDATE012DATENo00NoContentItemContentItemVOItemText1ITEM_TEXT_1PVAL037VARCHARNo300NoContentItemContentItemVOItemText2ITEM_TEXT_2PVAL038VARCHARNo300NoContentItemContentItemVOItemText3ITEM_TEXT_3PVAL039VARCHARNo300NoContentItemContentItemVOItemText4ITEM_TEXT_4PVAL040VARCHARNo300NoContentItemContentItemVOItemText5ITEM_TEXT_5PVAL041VARCHARNo300NoContentItemContentItemVOItemText6ITEM_TEXT_6PVAL042VARCHARNo300NoContentItemContentItemVOItemText7ITEM_TEXT_7PVAL043VARCHARNo300NoContentItemContentItemVOItemText8ITEM_TEXT_8PVAL044VARCHARNo300NoContentItemContentItemVOItemText9ITEM_TEXT_9PVAL045VARCHARNo300NoContentItemContentItemVOItemText10ITEM_TEXT_10PVAL046VARCHARNo300NoContentItemContentItemVOItemText11ITEM_TEXT_11PVAL047VARCHARNo300NoContentItemContentItemVOItemText12ITEM_TEXT_12PVAL048VARCHARNo300NoContentItemContentItemVOItemText13ITEM_TEXT_13PVAL049VARCHARNo300NoContentItemContentItemVOItemText14ITEM_TEXT_14PVAL050VARCHARNo300NoContentItemContentItemVOItemText15ITEM_TEXT_15PVAL051VARCHARNo300NoContentItemContentItemVOItemText16ITEM_TEXT_16PVAL052VARCHARNo300NoContentItemContentItemVOItemText17ITEM_TEXT_17PVAL053VARCHARNo300NoContentItemContentItemVOItemText18ITEM_TEXT_18PVAL054VARCHARNo300NoContentItemContentItemVOItemText19ITEM_TEXT_19PVAL055VARCHARNo300NoContentItemContentItemVOItemText20ITEM_TEXT_20PVAL056VARCHARNo300NoContentItemContentItemVOItemText21ITEM_TEXT_21PVAL057VARCHARNo300NoContentItemContentItemVOItemText22ITEM_TEXT_22PVAL058VARCHARNo300NoContentItemContentItemVOItemText23ITEM_TEXT_23PVAL059VARCHARNo300NoContentItemContentItemVOItemText24ITEM_TEXT_24PVAL060VARCHARNo300NoContentItemContentItemVOItemText25ITEM_TEXT_25PVAL061VARCHARNo300NoContentItemContentItemVOItemText26ITEM_TEXT_26PVAL062VARCHARNo300NoContentItemContentItemVOItemText27ITEM_TEXT_27PVAL063VARCHARNo300NoContentItemContentItemVOItemText28ITEM_TEXT_28PVAL064VARCHARNo300NoContentItemContentItemVOItemText29ITEM_TEXT_29PVAL065VARCHARNo300NoContentItemContentItemVOItemText30ITEM_TEXT_30PVAL066VARCHARNo300NoContentItemContentItemVOModuleIdMODULE_IDPVAL067VARCHARNo320NoContentItemContentItemRatingDescriptionVOContentRatingDescIdCONTENT_RATING_DESC_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectContentItemContentItemRatingDescriptionVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userContentItemContentItemRatingDescriptionVOContentTypeIdCONTENT_TYPE_IDPVAL003USRKEYNo360YesReference value used to identify Content Type (ContentTypeID in ContentTypeVO object)ContentItemContentItemRatingDescriptionVOContentItemIdCONTENT_ITEM_IDPVAL004USRKEYNo360YesReference value used to identify Content Item (ContentItemID in ContentItemVO object)ContentItemContentItemRatingDescriptionVORatingLevelIdRATING_LEVEL_IDPVAL005USRKEYNo360YesReference value used to identify Rating Level (RatingLevelID in RatingLevelVO object)ContentItemContentItemRatingDescriptionVOReviewRatingDescrREVIEW_RATING_DESCRPVAL006VARCHARNo40000NoContentItemRelationshipContentItemRelationshipVOContentItemRlatIdCONTENT_ITEM_RLAT_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectContentItemRelationshipContentItemRelationshipVOContentTypeIdCONTENT_TYPE_IDPVAL002USRKEYNo360YesReference value used to identify Content Type (ContentTypeID in ContentTypeVO object)ContentItemRelationshipContentItemRelationshipVOContentItemIdCONTENT_ITEM_IDPVAL003USRKEYNo360YesReference value used to identify Content Item (ContentItemID in ContentItemVO object)ContentItemRelationshipContentItemRelationshipVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userContentItemRelationshipContentItemRelationshipVORelatedContentTypeIdRELATED_CONTENT_TYPE_IDPVAL005USRKEYNo360YesReference value used to identify Related Content Type (ContentTypeID in ContentTypeVO object)ContentItemRelationshipContentItemRelationshipVORelatedContentItemIdRELATED_CONTENT_ITEM_IDPVAL006USRKEYNo360YesReference value used to identify Related Content Item (ContentItemID in ContentItemVO object)ContentItemRelationshipContentItemRelationshipVODateFromDATE_FROMPDATE001DATENo00YesContentItemRelationshipContentItemRelationshipVODateToDATE_TOPDATE002DATENo00NoContentItemRelationshipContentItemRelationshipVORelationshipCodeRELATIONSHIP_CODEPVAL007VARCHARNo300NoContentItemRelationshipContentItemRelationshipVOMandatoryFlagMANDATORY_FLAGPVAL008VARCHARNo300NoDepartmentDepartmentDetailVOOrgInformationIdORG_INFORMATION_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectDepartmentDepartmentDetailVOEffectiveEndDateEFFECTIVE_END_DATEPDATE001DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)DepartmentDepartmentDetailVOEffectiveStartDateEFFECTIVE_START_DATEPDATE002DATEYes00YesStart date of the date effective record (YYYY-MM-DD)DepartmentDepartmentDetailVOOrganizationIdORGANIZATION_IDPVAL002USRKEYNo360YesReference value used to identify Departmen t (DepartmentID in DepartmentVO object)DepartmentDepartmentDetailVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL003NUMERICNo186YesLeave blank - will be autogeneratedDepartmentDepartmentDetailVOLegislationCodeLEGISLATION_CODEPVAL004Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300NoLegislationCode of the DepartmentDepartmentDepartmentDetailVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateDepartmentDepartmentDetailVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateDepartmentDepartmentVOOrganizationIdORGANIZATION_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectDepartmentDepartmentVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)DepartmentDepartmentVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)DepartmentDepartmentVONameNAMEPVAL002VARCHARNo2400YesOrganization Name DepartmentDepartmentVOLocationIdLOCATION_IDPVAL003USRKEYNo360NoReference value used to identify Location (LocationID in LocationVO object), Location must be active on the EffectiveStartDateDepartmentDepartmentVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userDepartmentDepartmentVOSetIdSET_IDPVAL005USRKEYNo360NoThe GUID reference to the Set extracted from FusionDepartmentDepartmentVOLegalEntityIdLEGAL_ENTITY_IDPVAL006Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180NoLeave blankDepartmentDepartmentVOEstablishmentIdESTABLISHMENT_IDPVAL007NUMERICNo180NoLeave blankDepartmentDepartmentVOCostAllocationKeyflexIdCOST_ALLOCATION_KEYFLEX_IDPVAL008NUMERICNo180NoLeave blankDepartmentDepartmentVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL009NUMERICNo186YesLeave blank - will be autogeneratedDepartmentDepartmentVOStatusSTATUSPVAL010VARCHARNo300YesA or I (Active or Inactive)DepartmentDepartmentVOInternalExternalFlagINTERNAL_EXTERNAL_FLAGPVAL011VARCHARNo300NoINTDepartmentDepartmentVOInternalAddressLineINTERNAL_ADDRESS_LINEPVAL012VARCHARNo800NoFree textDepartmentDepartmentVOOrganizationTypeORGANIZATION_TYPEPVAL013VARCHARNo300NoValidated against ORG_TYPE lookupDepartmentDepartmentVOSourceLangSOURCE_LANGPVAL045VARCHARNo40YesUSDepartmentDepartmentVOActionOccurrenceId1ACTION_OCCURRENCE_ID1PVAL046NUMERICNo186YesLeave blank - it will be defaultedDepartmentDepartmentVOClassificationCodeCLASSIFICATION_CODEPVAL047VARCHARNo400YesDEPARTMENTDepartmentDepartmentVOLegislationCodeLEGISLATION_CODEPVAL048Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300NoLegislationCode of the DepartmentDepartmentDepartmentVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateDepartmentDepartmentVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateElementEntryElementEntryVOElementEntryIdELEMENT_ENTRY_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectElementEntryElementEntryVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)ElementEntryElementEntryVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)ElementEntryElementEntryVOPersonIdPERSON_IDPVAL002Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDateElementEntryElementEntryVOElementTypeIdELEMENT_TYPE_IDPVAL003USRKEYNo360YesThe GUID reference to the Element Type extracted from FusionElementEntryElementEntryVOEntryTypeENTRY_TYPEPVAL004Lookup TypePAY_ENTRY_TYPEVARCHARNo300YesIf entry can be by itselft or in conjunction with other entries. Default = "E" for Element EntryElementEntryElementEntryVOCreatorTypeCREATOR_TYPEPVAL005Lookup TypePAY_CREATOR_TYPEVARCHARNo300YesThe System that has created the Element Entry. Default = "H" for Batch Element EntryElementEntryElementEntryVOCreatorIdCREATOR_IDPVAL006NUMERICNo180NoElementEntryElementEntryVOBatchIdBATCH_IDPVAL007NUMERICNo180NoElementEntryElementEntryVOBatchActionIdBATCH_ACTION_IDPVAL008NUMERICNo180NoElementEntryElementEntryVOReasonREASONPVAL009VARCHARNo300NoElementEntryElementEntryVOTargetEntryIdTARGET_ENTRY_IDPVAL010NUMERICNo180NoElementEntryElementEntryVOSubprioritySUBPRIORITYPVAL011NUMERICNo90NoElementEntryElementEntryVODateEarnedDATE_EARNEDPDATE003DATENo00NoElementEntryElementEntryVOBalanceAdjCostFlagBALANCE_ADJ_COST_FLAGPVAL012VARCHARNo300NoElementEntryElementEntryVORelationshipIdRELATIONSHIP_IDPVAL013USRKEYNo360YesReference value used to identify Period of Service Id (PeriodOfServiceID in WorkRelationshipVO object)ElementEntryElementEntryVOTermIdTERM_IDPVAL014USRKEYNo360NoReference value used to identify Work Term (WorkTermID in WorkTermVO object)ElementEntryElementEntryVOAssignmentIdASSIGNMENT_IDPVAL015USRKEYNo360NoReference value used to identify Assignment (AssignmentID in AssignmentVO object)ElementEntryElementEntryVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateElementEntryElementEntryVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateElementEntryElementEntryValueVOElementEntryValueIdELEMENT_ENTRY_VALUE_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectElementEntryElementEntryValueVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)ElementEntryElementEntryValueVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)ElementEntryElementEntryValueVOInputValueIdINPUT_VALUE_IDPVAL002USRKEYNo360YesThe GUID reference to the Element Type's Input Value extracted from FusionElementEntryElementEntryValueVOElementEntryIdELEMENT_ENTRY_IDPVAL003USRKEYNo360YesReference value used to identify Element Entry (ElementEntryID in ElementEntryVO object)ElementEntryElementEntryValueVOScreenEntryValueSCREEN_ENTRY_VALUEPVAL004VARCHARNo600NoElementEntryElementEntryValueVOEntryUsageIdENTRY_USAGE_IDPVAL005NUMERICNo180NoLeave blankElementEntryElementEntryValueVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateElementEntryElementEntryValueVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateEstablishmentEstablishmentVOEstablishmentIdESTABLISHMENT_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectEstablishmentEstablishmentVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userEstablishmentEstablishmentVONameNAMEPVAL003VARCHARNo2400YesEstablishmentEstablishmentVOLocationLOCATIONPVAL004VARCHARNo2400NoEstablishmentEstablishmentVOSchoolCodeSCHOOL_CODEPVAL005VARCHARNo300YesEstablishmentEstablishmentVOPartyIdPARTY_IDPVAL006NUMERICNo180NoEstablishmentEstablishmentVODescriptionDESCRIPTIONPVAL007VARCHARNo2400YesEstablishmentEstablishmentVOCountryIdCOUNTRY_IDPVAL008NUMERICNo180NoEstablishmentEstablishmentVOStateProvinceIdSTATE_PROVINCE_IDPVAL009NUMERICNo180NoGradeGradeVOGradeIdGRADE_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectGradeGradeVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)GradeGradeVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)GradeGradeVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL002NUMERICNo180YesEnter 0GradeGradeVOSetIdSET_IDPVAL003USRKEYNo360YesThe GUID reference to the Set extracted from FusionGradeGradeVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userGradeGradeVONameNAMEPVAL005VARCHARNo2400YesNot uniqueGradeGradeVOGradeCodeGRADE_CODEPVAL006VARCHARNo300YesMust be unique within set or if in common set, unique across all setsGradeGradeVOStartingStepSTARTING_STEPPVAL007NUMERICNo180NoLeave blankGradeGradeVOCeilingStepIdCEILING_STEP_IDPVAL008NUMERICNo180NoLeave blankGradeGradeVOGradeTypeGRADE_TYPEPVAL009VARCHARNo300YesGRADEGradeGradeVOActiveStatusACTIVE_STATUSPVAL010VARCHARNo300YesA or I (Active or Inactive)GradeGradeVoLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateGradeGradeVoLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateGradeRateGradeRateValueVORate Value IDRATE_VALUE_IDPVAL001NUMERICYes180NoGradeRateGradeRateValueVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesGradeRateGradeRateValueVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)GradeRateGradeRateValueVOLegislationCodeLEGISLATION_CODEPVAL002Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300NoGradeRateGradeRateValueVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL003NUMERICNo180YesEnter 0GradeRateGradeRateValueVORateIdRATE_IDPVAL004USRKEYNo360YesGradeRateGradeRateValueVORateObjectTypeRATE_OBJECT_TYPEPVAL005VARCHARNo300YesGradeRateGradeRateValueVORateObjectIdRATE_OBJECT_IDPVAL006USRKEYNo360YesGradeRateGradeRateValueVORateSequenceSEQUENCEPVAL007NUMERICNo180NoGradeRateGradeRateValueVOMinimumMINIMUMPVAL008VARCHARNo200NoGradeRateGradeRateValueVOMaximumMAXIMUMPVAL009VARCHARNo200NoGradeRateGradeRateValueVOMidValueMID_VALUEPVAL010VARCHARNo200NoGradeRateGradeRateValueVOValueVALUEPVAL011VARCHARNo200NoGradeRateGradeRateValueVOAttributeCategoryATTRIBUTE_CATEGORYPVAL012VARCHARNo300NoGradeRateGradeRateValueVOInformationCategoryINFORMATION_CATEGORYPVAL013VARCHARNo300NoGradeRateGradeRateValueVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateGradeRateGradeRateValueVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateGradeRateGradeRateVORateIdRATE_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectGradeRateGradeRateVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)GradeRateGradeRateVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)GradeRateGradeRateVOLegislativeDataGroupIdLEGISLATIVE_DATA_GROUP_IDPVAL002USRKEYNo360YesGradeRateGradeRateVOLegislationCodeLEGISLATION_CODEPVAL003Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300NoGradeRateGradeRateVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL004NUMERICNo180YesEnter 0GradeRateGradeRateVORateTypeRATE_TYPEPVAL005VARCHARNo300YesGradeRateGradeRateVORateObjectTypeRATE_OBJECT_TYPEPVAL006VARCHARNo300YesGradeRateGradeRateVONameNAMEPVAL007VARCHARNo2400YesShould be a Grade Rate Name on the Salary Basis Grade Rate dropdownGradeRateGradeRateVOCurrencyCodeCURRENCY_CODEPVAL008VARCHARNo150YesGradeRateGradeRateVORateUomRATE_UOMPVAL009VARCHARNo300YesGradeRateGradeRateVORateFrequencyRATE_FREQUENCYPVAL010VARCHARNo300YesGradeRateGradeRateVOAnnualizationFactorANNUALIZATION_FACTORPVAL011NUMERICNo186NoGradeRateGradeRateVOActiveStatusACTIVE_STATUSPVAL012VARCHARNo300YesGradeRateGradeRateVOAttributeCategoryATTRIBUTE_CATEGORYPVAL013VARCHARNo300NoGradeRateGradeRateVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateGradeRateGradeRateVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateJobJobGradeVOValidGradeIdVALID_GRADE_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectJobJobGradeVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)JobJobGradeVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00NoEnd date of the date effective record (YYYY-MM-DD)JobJobGradeVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userJobJobGradeVOGradeIdGRADE_IDPVAL003USRKEYNo360YesReference value used to identify Grade (GradeId in GradeVO object)JobJobGradeVOPositionIdPOSITION_IDPVAL004USRKEYNo360NoLeave blankJobJobGradeVOJobIdJOB_IDPVAL005USRKEYNo360NoReference value used to identify parent Job (JobId in JobVO object)JobJobGradeVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL006NUMERICNo180YesEnter 0JobJobGradeVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateJobJobGradeVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateJobJobVOJobIdJOB_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectJobJobVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)JobJobVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)JobJobVOJobCodeJOB_CODEPVAL002VARCHARNo300YesMust be unique within set or if in common set, unique across all setsJobJobVONameNAMEPVAL003VARCHARNo2400YesNon-unique nameJobJobVOSetIdSET_IDPVAL004USRKEYNo360YesThe GUID reference to the Set extracted from FusionJobJobVOBusinessGroupIdBUSINESS_GROUP_IDPVAL005Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userJobJobVOJobFamilyIdJOB_FAMILY_IDPVAL006USRKEYNo360NoReference value used to identify JobFamily (JobFamilyID in JobFamilyVO object), JobFamily must be active on the EffectiveStartDateJobJobVOBenchmarkJobIdBENCHMARK_JOB_IDPVAL007NUMERICNo180NoReference value used to identify JobId (JobID in JobVO object), Benchmark Job must be active on the EffectiveStartDateJobJobVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL008NUMERICNo180YesEnter 0JobJobVOActiveStatusACTIVE_STATUSPVAL009VARCHARNo300YesA or I (Active or Inactive)JobJobVOBenchmarkJobFlagBENCHMARK_JOB_FLAGPVAL010VARCHARNo300NoY or NJobJobVOMedCheckupReqMED_CHECKUP_REQPVAL011VARCHARNo300NoY or NJobJobVORegularTemporaryREGULAR_TEMPORARYPVAL012VARCHARNo300NoValidated against REGULAR_TEMPORARY lookupJobJobVOFullPartTimeFULL_PART_TIMEPVAL013VARCHARNo300No??JobJobVOJobFunctionCodeJOB_FUNCTION_CODEPVAL014VARCHARNo300No??JobJobVOManagerLevelMANAGER_LEVELPVAL015VARCHARNo300No??JobJobVOApprovalAuthorityAPPROVAL_AUTHORITYPVAL016NUMERICNo380No??JobJobVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateJobJobVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateJobFamilyJobFamilyVOJobFamilyIdJOB_FAMILY_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectJobFamilyJobFamilyVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)JobFamilyJobFamilyVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)JobFamilyJobFamilyVOJobFamilyNameJOB_FAMILY_NAMEPVAL002VARCHARNo2400YesUnique Job Family NameJobFamilyJobFamilyVOBusinessGroupIdBUSINESS_GROUP_IDPVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userJobFamilyJobFamilyVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL004NUMERICNo180NoEnter 0JobFamilyJobFamilyVOActiveStatusACTIVE_STATUSPVAL005VARCHARNo300YesA or I (Active or Inactive)JobFamilyJobFamilyVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateJobFamilyJobFamilyVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateLocationLocationVOLocationIdLOCATION_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectLocationLocationVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)LocationLocationVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)LocationLocationVOSetIdSET_IDPVAL002USRKEYNo360YesThe GUID reference to the Set extracted from FusionLocationLocationVOBusinessGroupIdBUSINESS_GROUP_IDPVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userLocationLocationVOLocationImageUrlLOCATION_IMAGE_URLPVAL004VARCHARNo10000NoLeave blankLocationLocationVOAddressUsageTypeADDRESS_USAGE_TYPEPVAL005VARCHARNo300YesValidated against LOCATION_ADDRESS_USAGE_TYPE lookup codeLocationLocationVOActiveStatusACTIVE_STATUSPVAL006VARCHARNo300YesValidated against ACTIVE_INACTIVE lookup codeLocationLocationVOTelephoneNumber1TELEPHONE_NUMBER_1PVAL007VARCHARNo2400NoLocationLocationVOTelephoneNumber2TELEPHONE_NUMBER_2PVAL008VARCHARNo2400NoLocationLocationVOTelephoneNumber3TELEPHONE_NUMBER_3PVAL009VARCHARNo2400NoLocationLocationVOMainphoneAreaCode1MAINPHONE_AREA_CODE1PVAL010VARCHARNo600NoLocationLocationVOMainphoneCountryCode1MAINPHONE_COUNTRY_CODE1PVAL011VARCHARNo300NoLocationLocationVOMainphoneExtension1MAINPHONE_EXTENSION1PVAL012VARCHARNo600NoLocationLocationVOMainphoneSubscriberNum1MAINPHONE_SUBSCRIBER_NUM1PVAL013VARCHARNo600NoLocationLocationVOFaxAreaCode2FAX_AREA_CODE2PVAL014VARCHARNo600NoLocationLocationVOFaxCountryCode2FAX_COUNTRY_CODE2PVAL015VARCHARNo300NoLocationLocationVOFaxExtension2FAX_EXTENSION2PVAL016VARCHARNo600NoLocationLocationVOFaxSubscriberNum2FAX_SUBSCRIBER_NUM2PVAL017VARCHARNo600NoLocationLocationVOOtherphoneAreaCode3OTHERPHONE_AREA_CODE3PVAL018VARCHARNo600NoLocationLocationVOOtherphoneCountryCode3OTHERPHONE_COUNTRY_CODE3PVAL019VARCHARNo300NoLocationLocationVOOtherphoneExtension3OTHERPHONE_EXTENSION3PVAL020VARCHARNo600NoLocationLocationVOOtherphoneSubscriberNum3OTHERPHONE_SUBSCRIBER_NUM3PVAL021VARCHARNo600NoLocationLocationVOOfficialLanguageCodeOFFICIAL_LANGUAGE_CODEPVAL022VARCHARNo300NoLocationLocationVOEmailAddressEMAIL_ADDRESSPVAL023VARCHARNo2400NoLocationLocationVOShipToSiteFlagSHIP_TO_SITE_FLAGPVAL024VARCHARNo300NoLocationLocationVOShipToLocationIdSHIP_TO_LOCATION_IDPVAL025NUMERICNo180NoLeave blankLocationLocationVOReceivingSiteFlagRECEIVING_SITE_FLAGPVAL026VARCHARNo300NoLocationLocationVOBillToSiteFlagBILL_TO_SITE_FLAGPVAL027VARCHARNo300NoLocationLocationVOOfficeSiteFlagOFFICE_SITE_FLAGPVAL028VARCHARNo300NoLocationLocationVODesignatedReceiverIdDESIGNATED_RECEIVER_IDPVAL029NUMERICNo180NoLocationLocationVOInventoryOrganizationIdINVENTORY_ORGANIZATION_IDPVAL030NUMERICNo180NoLocationLocationVOGeoHierarchyNodeIdGEO_HIERARCHY_NODE_IDPVAL031VARCHARNo320NoLocationLocationVOGeoHierarchyNodeValueGEO_HIERARCHY_NODE_VALUEPVAL032VARCHARNo1000NoLocationLocationVOInternalLocationCodeINTERNAL_LOCATION_CODEPVAL033VARCHARNo1200YesMust be unique within set or if in common set, unique across all sets (visible as Location Code in UI)LocationLocationVOLocationCodeLOCATION_CODE1PVAL034VARCHARNo600YesVisible in UI as Location NameLocationLocationVOLocationNameLOCATION_NAMEPVAL035VARCHARNo2400YesNot in UILocationLocationVODescriptionDESCRIPTIONPVAL036VARCHARNo2400NoLocationLocationVOAcLocationCodeAC_LOCATION_CODEPVAL037VARCHARNo600NoLocationLocationVOAddressLine1ADDRESS_LINE_1PVAL038VARCHARNo2400NoLocationLocationVOAddressLine2ADDRESS_LINE_2PVAL039VARCHARNo2400NoLocationLocationVOAddressLine3ADDRESS_LINE_3PVAL040VARCHARNo2400NoLocationLocationVOAddressLine4ADDRESS_LINE_4PVAL041VARCHARNo2400NoLocationLocationVOBuildingBUILDINGPVAL042VARCHARNo2400NoLocationLocationVOCountryCOUNTRYPVAL043Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo600YesValidated against TERRITORY_CODE in Territories ( see lookups csv)LocationLocationVOFloorNumberFLOOR_NUMBERPVAL044VARCHARNo400NoLocationLocationVOLongPostalCodeLONG_POSTAL_CODEPVAL045VARCHARNo300NoLocationLocationVOPostalCodePOSTAL_CODEPVAL046VARCHARNo300NoLocationLocationVORegion1REGION_1PVAL047VARCHARNo1200NoLocationLocationVORegion2REGION_2PVAL048VARCHARNo1200NoLocationLocationVORegion3REGION_3PVAL049VARCHARNo1200NoLocationLocationVOTimezoneCodeTIMEZONE_CODEPVAL050VARCHARNo500NoLocationLocationVOTownOrCityTOWN_OR_CITYPVAL051VARCHARNo300NoLocationLocationVOP Location CodeP_LOCATION_CODEPVAL052LocationLocationVOBusinessGroupId1BUSINESS_GROUP_ID1PVAL053Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be defaultedLocationLocationVOSet ID1SET_ID1PVAL054LocationLocationVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateLocationLocationVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePassportPassportVOPassportIdPASSPORT_IDPrimary keyIdUSRKEYYesYesPrimary key - use unique identifier of objectPassportPassportVOPersonIdPERSON_IDForeign KeyPersonVO.PersonIdNUMBERNoYesReference value used to identify Person (PersonID in PersonVO object)PassportPassportVOBusinessGroupIdBUSINESS_GROUP_IDForeign KeyNUMBERNoYesLeave blank - it will be set to the Enterprise of the invoking userPassportPassportVOLegislationCodeLEGISLATION_CODETable LookupVARCHARNoYesBased on data in FND_TERRITORIESPassportPassportVOPassportNumberPASSPORT_NUMBERVARCHARNoNoPassportPassportVOPassportTypePASSPORT_TYPELookup TypeVARCHARNoNoValidated against lookup code in PER_PASSPORT_TYPE LookupPassportPassportVOIssueDateISSUE_DATEDATENoNoPassportPassportVOExpirationDateEXPIRATION_DATEDATENoNoPassportPassportVOIssuingAuthorityISSUING_AUTHORITYVARCHARNoNoPassportPassportVOIssuingCountryISSUING_COUNTRYTable LookupVARCHARNoNobased on data in FND_TERRITORIESPassportPassportVOIssuingLocationISSUING_LOCATIONVARCHARNoNoPassportPassportVOProfessionPROFESSIONVARCHARNoNoPersonPersonAddressVOPersonAddrUsageIdPERSON_ADDR_USAGE_IDPVAL001SurrogateIdPersonAddressVO.PersonAddrUsageIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonAddressVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PersonPersonAddressVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PersonPersonAddressVOPersonIdPERSON_IDPVAL002Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonAddressVOBusinessGroupIdBUSINESS_GROUP_IDPVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonAddressVOBusinessGroupId1BUSINESS_GROUP_ID1PVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180NoLeave blank - it will be set to the Enterprise of the invoking userPersonPersonAddressVOAddressTypeADDRESS_TYPEPVAL005Lookup TypeADDRESS_TYPEVARCHARNo300YesValidated against ADDRESS_TYPE lookupPersonPersonAddressVOAddressLine1ADDRESS_LINE_1PVAL006VARCHARNo2400NoPersonPersonAddressVOAddressLine2ADDRESS_LINE_2PVAL007VARCHARNo2400NoPersonPersonAddressVOAddressLine3ADDRESS_LINE_3PVAL008VARCHARNo2400NoPersonPersonAddressVOAddressLine4ADDRESS_LINE_4PVAL009VARCHARNo2400NoPersonPersonAddressVOBuildingBUILDINGPVAL010VARCHARNo2400NoPersonPersonAddressVOFloorNumberFLOOR_NUMBERPVAL011VARCHARNo400NoPersonPersonAddressVOTownOrCityTOWN_OR_CITYPVAL012VARCHARNo300NoPersonPersonAddressVORegion1REGION_1PVAL013VARCHARNo1200NoPersonPersonAddressVORegion2REGION_2PVAL014VARCHARNo1200NoPersonPersonAddressVORegion3REGION_3PVAL015VARCHARNo1200NoPersonPersonAddressVOCountryCOUNTRYPVAL016Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo600YesValidated against TERRITORY_CODE in Territories ( see lookups csv)PersonPersonAddressVOPostalCodePOSTAL_CODEPVAL017VARCHARNo300NoCountry specific validationPersonPersonAddressVOLongPostalCodeLONG_POSTAL_CODEPVAL018VARCHARNo300NoPersonPersonAddressVOTimezoneCodeTIMEZONE_CODEPVAL019VARCHARNo500NoPersonPersonAddressVODerivedLocaleDERIVED_LOCALEPVAL020VARCHARNo2400NoPersonPersonAddressVODqValidationLevelDQ_VALIDATION_LEVELPVAL021NUMERICNo10NoPersonPersonAddressVOFormattedSingleLineAddressFORMATTED_SINGLE_LINE_ADDRESSPVAL022VARCHARNo20000NoPersonPersonAddressVOFormattedMultiLineAddressFORMATTED_MULTI_LINE_ADDRESSPVAL023VARCHARNo20000NoPersonPersonAddressVOMailingAddressFlagMAILING_ADDRESS_FLAGPVAL024VARCHARNo20000NoPersonPersonAddressVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePersonPersonAddressVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePersonPersonEmailVOEmailAddressIdEMAIL_ADDRESS_IDPVAL001SurrogateIdPersonEmailVO.EmailAddressIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonEmailVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonEmailVOPersonIdPERSON_IDPVAL003Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonEmailVODateFromDATE_FROMPDATE001DATENo00YesPersonPersonEmailVODateToDATE_TOPDATE002DATENo00NoPersonPersonEmailVOEmailTypeEMAIL_TYPEPVAL004Lookup TypeEMAIL_TYPEVARCHARNo300YesValidated against EMAIL_TYPE lookupPersonPersonEmailVOEmailAddressEMAIL_ADDRESSPVAL005VARCHARNo2400YesEmail Address must meet the followign regular expression: [A-Za-z0-9._#!$&'*/=?^`{}~|%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}PersonPersonEmailVOMasteredInLdapFlagMASTERED_IN_LDAP_FLAGPVAL006VARCHARNo300NoLeave blankPersonPersonEmailVOPrimaryFlagPRIMARY_FLAGPVAL007VARCHARNo20000NoLeave blankPersonPersonEthnicityVOEthnicityIdETHNICITY_IDPVAL001SurrogateIdPersonEthnicityVOUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonEthnicityVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonEthnicityVOLegislationCodeLEGISLATION_CODEPVAL003Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300YesValidated against TERRITORY_CODE in Territories ( see lookups csv)PersonPersonEthnicityVOPersonIdPERSON_IDPVAL004Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonEthnicityVODeclarerIdDECLARER_IDPVAL005Foreign KeyIdPersonVO.PersonIdNUMERICNo180NoLeave blankPersonPersonEthnicityVOEthnicityETHNICITYPVAL006Lookup TypePER_ETHNICITYVARCHARNo300YesValidated against PER_ETHNICITY lookupPersonPersonEthnicityVOPrimaryFlagPRIMARY_FLAGPVAL007VARCHARNo300YesY or NPersonPersonLegislativeDataVOPersonLegislativeIdPERSON_LEGISLATIVE_IDPVAL001SurrogateIdPersonLegislativeDataVO.PersonLegislativeDataVOUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonLegislativeDataVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PersonPersonLegislativeDataVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PersonPersonLegislativeDataVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonLegislativeDataVOPersonIdPERSON_IDPVAL003Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonLegislativeDataVOLegislationCodeLEGISLATION_CODEPVAL004Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300YesValidated against TERRITORY_CODE in Territories ( see lookups csv)PersonPersonLegislativeDataVOHighestEducationLevelHIGHEST_EDUCATION_LEVELPVAL005Lookup TypePER_HIGHEST_EDUCATION_LEVELVARCHARNo300NoValidated against PER_HIGHEST_EDUCATION_LEVEL lookupPersonPersonLegislativeDataVOMaritalStatusMARITAL_STATUSPVAL006Lookup TypeMAR_STATUSVARCHARNo300NoValidated against MAR_STATUS lookup. M, S or D. "U" can cause issuesPersonPersonLegislativeDataVOMaritalStatusDateMARITAL_STATUS_DATEPDATE003DATENo00NoPersonPersonLegislativeDataVOSexSEXPVAL007Lookup TypeSEXVARCHARNo300NoValidated against SEX lookupPersonPersonLegislativeDataVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePersonPersonLegislativeDataVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePersonPersonNameVOPersonNameIdPERSON_NAME_IDPVAL001SurrogateIdPersonNameVO.PersonNameIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonNameVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PersonPersonNameVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PersonPersonNameVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonNameVOLegislationCodeLEGISLATION_CODEPVAL003Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo40NoPersonPersonNameVOPersonIdPERSON_IDPVAL004Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonNameVONameTypeNAME_TYPEPVAL005Lookup TypeNAME_TYPEVARCHARNo300YesGLOBALPersonPersonNameVOFirstNameFIRST_NAMEPVAL006VARCHARNo1500NoPersonPersonNameVOMiddleNamesMIDDLE_NAMESPVAL007VARCHARNo800NoCannot be blank spacePersonPersonNameVOLastNameLAST_NAMEPVAL008VARCHARNo1500YesPersonPersonNameVODisplayNameDISPLAY_NAMEPVAL009VARCHARNo2400NoConcatenation of Names required for display purposes - will be defaulted if left blankPersonPersonNameVOOrderNameORDER_NAMEPVAL010VARCHARNo2400YesConcatenation of Names required for ordering purposes - will be defaulted if left blankPersonPersonNameVOListNameLIST_NAMEPVAL011VARCHARNo2400NoPersonPersonNameVOFullNameFULL_NAMEPVAL012VARCHARNo20000NoPersonPersonNameVOHonorsHONORSPVAL013VARCHARNo800NoPersonPersonNameVOKnownAsKNOWN_ASPVAL014VARCHARNo800NoPersonPersonNameVOPreNameAdjunctPRE_NAME_ADJUNCTPVAL015VARCHARNo1500NoPersonPersonNameVOPreviousLastNamePREVIOUS_LAST_NAMEPVAL016VARCHARNo1500NoPersonPersonNameVOSuffixSUFFIXPVAL017VARCHARNo800NoPersonPersonNameVOTitleTITLEPVAL018Lookup TypeTITLEVARCHARNo300NoValidated against TITLE lookup. Can be NULL but not blank space.PersonPersonNameVOMilitaryRankMILITARY_RANKPVAL019VARCHARNo800NoPersonPersonNameVOCharSetContextCHAR_SET_CONTEXTPVAL020Table LookupFND_LANGUAGES_B.LANGUAGE_CODEVARCHARNo40NoPersonPersonNameVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePersonPersonNameVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePersonPersonNationalIdentifierVONationalIdentifierIdNATIONAL_IDENTIFIER_IDPVAL001SurrogateIdPersonNationalIdentifierVO.NationalIdentifierIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonNationalIdentifierVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonNationalIdentifierVOPersonIdPERSON_IDPVAL003Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonNationalIdentifierVOLegislationCodeLEGISLATION_CODEPVAL004Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300YesValidated against TERRITORY_CODE in Territories ( see lookups csv)PersonPersonNationalIdentifierVOIssueDateISSUE_DATEPDATE001DATENo00NoPersonPersonNationalIdentifierVOExpirationDateEXPIRATION_DATEPDATE002DATENo00NoExpiration date must be after Issue date if enteredPersonPersonNationalIdentifierVONationalIdentifierTypeNATIONAL_IDENTIFIER_TYPEPVAL005Lookup TypePER_NATIONAL_IDENTIFIER_TYPEVARCHARNo300YesValidated against PER_NATIONAL_IDENTIFIER_TYPE lookupPersonPersonNationalIdentifierVONationalIdentifierNumberNATIONAL_IDENTIFIER_NUMBERPVAL006VARCHARNo300NoValidated against rules for the LegislationPersonPersonNationalIdentifierVOPlaceOfIssuePLACE_OF_ISSUEPVAL007VARCHARNo300NoPersonPersonNationalIdentifierVOPrimaryFlagPRIMARY_FLAGPVAL008VARCHARNo20000NoLeave blankPersonPersonPhoneVOPhoneIdPHONE_IDPVAL001SurrogateIdPersonPhoneVO.PhoneIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonPhoneVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonPhoneVOPhoneTypePHONE_TYPEPVAL003Lookup TypePHONE_TYPEVARCHARNo300YesValidated against PHONE_TYPE lookupPersonPersonPhoneVODateFromDATE_FROMPDATE001DATENo00YesPersonPersonPhoneVODateToDATE_TOPDATE002DATENo00NoPersonPersonPhoneVOPersonIdPERSON_IDPVAL004Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonPhoneVOPhoneNumberPHONE_NUMBERPVAL005VARCHARNo600YesPersonPersonPhoneVOCountryCodeNumberCOUNTRY_CODE_NUMBERPVAL006VARCHARNo300NoPersonPersonPhoneVOExtensionEXTENSIONPVAL007VARCHARNo600NoPersonPersonPhoneVOSpeedDialNumberSPEED_DIAL_NUMBERPVAL008VARCHARNo600NoPersonPersonPhoneVOValidityVALIDITYPVAL009Lookup TypePER_CONTACT_TIMESVARCHARNo300NoValidated against IRC_CONTACT_TIMES lookupPersonPersonPhoneVOAreaCodeAREA_CODEPVAL010VARCHARNo300NoPersonPersonPhoneVOSearchPhoneNumberSEARCH_PHONE_NUMBERPVAL011VARCHARNo2400NoPersonPersonPhoneVOLegislationCodeLEGISLATION_CODEPVAL012Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo40NoPersonPersonPhoneVOPrimaryFlagPRIMARY_FLAGPVAL013VARCHARNo20000NoLeave blankPersonPersonReligionVOReligionIdRELIGION_IDPVAL001SurrogateIdPersonReligionVO.ReligionIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonReligionVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonReligionVOPersonIdPERSON_IDPVAL003Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonReligionVOLegislationCodeLEGISLATION_CODEPVAL004Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300YesValidated against TERRITORY_CODE in Territories ( see lookups csv)PersonPersonReligionVOPrimaryFlagPRIMARY_FLAGPVAL005VARCHARNo300YesY or NPersonPersonReligionVOReligionRELIGIONPVAL006Lookup TypePER_RELIGIONVARCHARNo300YesValidated against PER_RELIGION lookupPersonPersonTypeUsageVOPersonTypeUsageIdPERSON_TYPE_USAGE_IDPVAL001SurrogateIdPersonTypeUsageVO.PersonTypeUsageIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonTypeUsageVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PersonPersonTypeUsageVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PersonPersonTypeUsageVOEffectiveSequenceEFFECTIVE_SEQUENCEPVAL002USRKEYYes360YesIndicator of the sequence of date effective change within a dayPersonPersonTypeUsageVOEffectiveLatestChangeEFFECTIVE_LATEST_CHANGEPVAL003VARCHARYes1200YesPersonPersonTypeUsageVOPersonIdPERSON_IDPVAL004Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePersonPersonTypeUsageVOPersonTypeIdPERSON_TYPE_IDPVAL005Foreign KeyIdPER_PERSON_TYPES.PERSON_TYPE_IDUSRKEYNo360YesThe GUID reference to the Person Type extracted from FusionPersonPersonTypeUsageVOSystemPersonTypeSYSTEM_PERSON_TYPEPVAL006Lookup TypeSYSTEM_PERSON_TYPEVARCHARNo300YesValidated against PersonTypes (defined in Fusion and extracted in XREF file)PersonPersonTypeUsageVOLegalEntityIdLEGAL_ENTITY_IDPVAL007Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDUSRKEYNo360NoThe GUID reference to the Legal Entity extracted from FusionPersonPersonTypeUsageVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePersonPersonTypeUsageVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePersonPersonVOPersonIdPERSON_IDPVAL001SurrogateIdPersonVO.PersonIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonPersonVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PersonPersonVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PersonPersonVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonVOBusinessGroupId1BUSINESS_GROUP_ID1PVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonPersonVOStartDateSTART_DATEPDATE003DATENo00YesEarliest effecitive start datePersonPersonVOStartDate1START_DATE1PDATE004DATENo00YesEarliest effecitive start datePersonPersonVOCorrespondenceLanguageCORRESPONDENCE_LANGUAGEPVAL004Table LookupFND_LANGUAGES_B.LANGUAGE_CODEVARCHARNo300NoValidated against LANGUAGE_CODE in Languages ( see lookups csv)PersonPersonVOBloodTypeBLOOD_TYPEPVAL005Lookup TypeBLOOD_TYPEVARCHARNo300NoValidated against BLOOD_TYPE lookup codePersonPersonVODateOfBirthDATE_OF_BIRTHPDATE005DATENo00NoPersonPersonVODateOfDeathDATE_OF_DEATHPDATE006DATENo00NoPersonPersonVOCountryOfBirthCOUNTRY_OF_BIRTHPVAL006Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo2400NoValidated against TERRITORY_CODE in Territories ( see lookups csv)PersonPersonVORegionOfBirthREGION_OF_BIRTHPVAL007VARCHARNo2400NoPersonPersonVOTownOfBirthTOWN_OF_BIRTHPVAL008VARCHARNo2400NoPersonPersonVOUserGuidUSER_GUIDPVAL009VARCHARNo640No??PersonPersonVOPersonNumberPERSON_NUMBERPVAL010VARCHARNo300YesPersonPersonVOPrimaryEmailIdPRIMARY_EMAIL_IDPVAL011Foreign KeyIdPER_EMAIL_ADDRESSES.EMAIL_ADDRESS_IDNUMERICNo180NoLeave blankPersonPersonVOPrimaryNatidIdPRIMARY_NID_IDPVAL012Foreign KeyIdPER_NATIONAL_IDENTIFIER_TYPES.NATIONAL_IDENTIFIER_IDNUMERICNo180NoLeave blankPersonPersonVOPrimaryNatidNumberPRIMARY_NID_NUMBERPVAL013VARCHARNo300NoLeave blankPersonPersonVOPrimaryPhoneIdPRIMARY_PHONE_IDPVAL014Foreign KeyIdPER_PHONES.PHONE_IDNUMERICNo180NoLeave blankPersonPersonVOMailingAddressIdMAILING_ADDRESS_IDPVAL015Foreign KeyIdPER_ADDRESSES_F.ADDRESS_IDNUMERICNo180NoLeave blankPersonPersonVOWaiveDataProtectWAIVE_DATA_PROTECTPVAL016VARCHARNo300YesY or NPersonPersonVOApplicantNumberAPPLICANT_NUMBERPVAL017VARCHARNo300NoPersonPersonVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePersonPersonVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePersonContactPersonContactVOBeneficiaryFlagBENEFICIARY_FLAG PVAL008VARCHARPersonContactPersonContactVOBondholderFlagBONDHOLDER_FLAG PVAL009 VARCHARPersonContactPersonContactVOBusinessGroupIdBUSINESS_GROUP_ID PVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_ID NUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonContactPersonContactVOContactPersonIDCONTACT_PERSON_ID PVAL003 NUMERICPersonContactPersonContactVOContactRelationshipIDCONTACT_RELATIONSHIP_ID PVAL001 NUMERICPersonContactPersonContactVOContactTypeCONTACT_TYPE PVAL005 VARCHARPersonContactPersonContactVODependentFlagDEPENDENT_FLAG PVAL010 VARCHARPersonContactPersonContactVOPersonIDPERSON_ID PVAL002 Foreign KeyPersonVO.PersonIdNUMERICNo360YesReference value used to identify Person (PersonID in PersonVO object)PersonContactPersonContactVOPersonalFlagPERSONAL_FLAG PVAL012 VARCHARPersonContactPersonContactVOPrimaryContactFlagPRIMARY_CONTACT_FLAG PVAL013 VARCHARPersonContactPersonContactVORltdPerRsdsWDsgntrFlagRLTD_PER_RSDS_W_DSGNTR_FLAG PVAL014 VARCHARPersonContactPersonContactVOSequenceNumberSEQUENCE_NUMBER PVAL017 NUMERICPersonContactPersonContactVOEffectiveStartDateEFFECTIVE_START_DATE PDATE001 DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PersonContactPersonContactVOEffectiveEndDateEFFECTIVE_END_DATE PDATE002 DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PersonContactPersonContactVOEmergencyContactFlagEMERGENCY_CONTACT_FLAG PVAL011 VARCHARPersonContactPersonContactVOExistingPersonEXISTING_PERSON PVAL016 VARCHARPersonContactPersonContactVOEndLifeReasonIDEND_LIFE_REASON_ID PVAL007 VARCHARPersonContactPersonContactVOStartLifeReasonIDSTART_LIFE_REASON_ID PVAL006 VARCHARPersonContactPersonContactVOThirdPartyPayFlagTHIRD_PARTY_PAY_FLAG PVAL015 VARCHARPersonDocumentationPersonCitizenshipVOCitizenshipIdCITIZENSHIP_IDPVAL001SurrogateIdPersonCitizenshipVO.CitizenshipIdUSRKEYYes360YesPrimary key - use unique identifier of objectPersonDocumentationPersonCitizenshipVOPersonIdPERSON_IDPVAL002Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonDocumentationVO object)PersonDocumentationPersonCitizenshipVOBusinessGroupIdBUSINESS_GROUP_IDPVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPersonDocumentationPersonCitizenshipVOLegislationCodeLEGISLATION_CODEPVAL004Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo300YesValidated against NATIONALITY lookupPersonDocumentationPersonCitizenshipVODateFromDATE_FROMPDATE001DATENo00NoPersonDocumentationPersonCitizenshipVODateToDATE_TOPDATE002DATENo00NoPersonDocumentationPersonCitizenshipVOCitizenshipStatusCITIZENSHIP_STATUSPVAL005Lookup TypePER_CITIZENSHIP_STATUSVARCHARNo300YesValidated against PER_CITIZENSHIP_STATUS lookupPersonDocumentationPersonDocumentationVOPersonIdPERSON_IDPVAL001Foreign KeyIdPersonVO.PersonIdUSRKEYYes360YesPrimary key - use unique identifier of object (this must be the same value as the Person reference used in PersonVO)PositionPositionGradeVOValidGradeIdVALID_GRADE_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectPositionPositionGradeVOPositionIdPOSITION_IDPVAL002USRKEYNo360NoPositionPositionGradeVOJobIdJOB_IDPVAL003USRKEYNo360NoPositionPositionGradeVOGradeIdGRADE_IDPVAL004USRKEYNo360YesPositionPositionGradeVOBusinessGroupIdBUSINESS_GROUP_IDPVAL005Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPositionPositionGradeVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL006NUMERICNo180YesEnter 0PositionPositionGradeVOEffectiveEndDateEFFECTIVE_END_DATEPDATE001DATEYes00NoEnd date of the date effective record (YYYY-MM-DD)PositionPositionGradeVOEffectiveStartDateEFFECTIVE_START_DATEPDATE002DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PositionPositionGradeVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePositionPositionGradeVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DatePositionPositionVOPositionIdPOSITION_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectPositionPositionVOEffectiveStartDateEFFECTIVE_START_DATEPDATE001DATEYes00YesStart date of the date effective record (YYYY-MM-DD)PositionPositionVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)PositionPositionVOBusinessUnitIdBUSINESS_UNIT_IDPVAL002USRKEYNo360YesPositionPositionVOPositionCodePOSITION_CODEPVAL003VARCHARNo300YesPositionPositionVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userPositionPositionVODepartmentIdORGANIZATION_IDPVAL005USRKEYNo360YesPositionPositionVOJobIdJOB_IDPVAL006USRKEYNo360YesPositionPositionVOLocationIdLOCATION_IDPVAL007USRKEYNo360NoPositionPositionVOEntryGradeIdENTRY_GRADE_IDPVAL008NUMERICNo180NoPositionPositionVOEntryStepIdENTRY_STEP_IDPVAL009NUMERICNo180NoPositionPositionVOStatusACTIVE_STATUSPVAL010VARCHARNo300YesPositionPositionVOSupervisorIdSUPERVISOR_IDPVAL011USRKEYNo360NoPositionPositionVOSupervisorAssignmentIdSUPERVISOR_ASSIGNMENT_IDPVAL012USRKEYNo360NoPositionPositionVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL013NUMERICNo180YesEnter 0PositionPositionVORegularTemporaryPERMANENT_TEMPORARY_FLAGPVAL014VARCHARNo300NoPositionPositionVOFteFTEPVAL015NUMERICNo102NoPositionPositionVOHiringStatusHIRING_STATUSPVAL016VARCHARNo300YesPositionPositionVOFullPartTimeFULL_PART_TIMEPVAL017VARCHARNo300NoPositionPositionVOFrequencyFREQUENCYPVAL018VARCHARNo300NoPositionPositionVOTimeNormalStartTIME_NORMAL_STARTPVAL019VARCHARNo50NoPositionPositionVOTimeNormalFinishTIME_NORMAL_FINISHPVAL020VARCHARNo50NoPositionPositionVOPositionTypePOSITION_TYPEPVAL021VARCHARNo300NoPositionPositionVOProbationPeriodUnitCdPROBATION_PERIOD_UNIT_CDPVAL022VARCHARNo300NoPositionPositionVOBargainingUnitCdBARGAINING_UNIT_CDPVAL023VARCHARNo300NoPositionPositionVOMaxPersonsMAX_PERSONSPVAL024NUMERICNo40NoPositionPositionVOWorkingHoursWORKING_HOURSPVAL025NUMERICNo223NoPositionPositionVOOverlapAllowedOVERLAP_ALLOWEDPVAL026VARCHARNo300NoPositionPositionVOSeasonalFlagSEASONAL_FLAGPVAL027VARCHARNo300NoPositionPositionVOProbationPeriodPROBATION_PERIODPVAL028NUMERICNo222NoPositionPositionVOSeasonalEndDateSEASONAL_END_DATEPDATE003DATENo00NoPositionPositionVOSecurityClearanceSECURITY_CLEARANCEPVAL029VARCHARNo300NoPositionPositionVOSeasonalStartDateSEASONAL_START_DATEPDATE004DATENo00NoPositionPositionVOAttributeCategoryATTRIBUTE_CATEGORYPVAL030VARCHARNo300NoPositionPositionVONameNAMEPVAL031VARCHARNo2400NoPositionPositionVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DatePositionPositionVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateProfileProfileVOProfileIdPROFILE_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of object. Customer can provide a random unique value.ProfileProfileVODescriptionDESCRIPTIONPVAL002VARCHARNo40000NoName of Person (eg Stewart Holmes)ProfileProfileVOSummarySUMMARYPVAL003VARCHARNo40000NoLeave BlankProfileProfileVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesSpecify "1" or Leave blank - it will be set to the Enterprise of the invoking userProfileProfileVOProfileTypeIdPROFILE_TYPE_IDPVAL005USRKEYNo360YesGUID value to be obtained from Key Map Reference table corresponding to OBJECT_NAME = HRT_PROFILE_TYPE_VO and Additional Description of Person ProfileProfileVOProfileCodePROFILE_CODEPVAL006VARCHARNo300YesLeave Blank, it will be defaultedProfileProfileVOProfileStatusCodePROFILE_STATUS_CODEPVAL007VARCHARNo300Yes"A" (Lookup Code to indicate Active)ProfileProfileVOProfileUsageCodePROFILE_USAGE_CODEPVAL008VARCHARNo300Yes"P" (Lookup Code to indicate Person Profile)ProfileProfileVOPersonIdPERSON_IDPVAL009Foreign KeyIdPersonVO.PersonIdUSRKEYNo360NoGUID value to be obtained from Key Map Reference table corresponding to OBJECT_NAME = PERSON_VO and Additional Description of the person name for whom we are creating the Profile. Person must be exist on the EffectiveStartDateProfileProfileVOPartyIdPARTY_IDPVAL010NUMERICNo180NoLeave BlankProfileProfileVOOwnerPersonIdOWNER_PERSON_IDPVAL011USRKEYNo360NoGUID thats the same as used for PERSON_ID above ProfileProfileRelationVOProfileRelationIdPROFILE_RELATION_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectProfileProfileRelationVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userProfileProfileRelationVORelationIdRELATION_IDPVAL003USRKEYNo360YesProfileProfileRelationVOProfileIdPROFILE_IDPVAL004USRKEYNo360YesProfileProfileRelationVOObjectIdOBJECT_IDPVAL005USRKEYNo360YesProfileProfileRelationVOObjectEffStartDateOBJECT_EFF_START_DATEPDATE001DATENo00YesProfileProfileRelationVOObjectEffEndDateOBJECT_EFF_END_DATEPDATE002DATENo00NoProfileProfileItemVOProfileItemIdPROFILE_ITEM_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectProfileProfileItemVOProfileIdPROFILE_IDPVAL002USRKEYNo360YesGUID that was used earlier to load the Profile record for the respecting Person ProfileProfileItemVOBusinessGroupIdBUSINESS_GROUP_IDPVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userProfileProfileItemVOContentTypeIdCONTENT_TYPE_IDPVAL004USRKEYNo360YesGUID from Key Map reference data corresponding to OBJECT_NAME=HRT_CONTENT_TYPE_VO and ADDITIONAL_INFO=Degrees ProfileProfileItemVOContentItemIdCONTENT_ITEM_IDPVAL005USRKEYNo360NoGUID from Key Map Reference table corresponding to OBJECT_NAME = CONTENT_ITEM_VO and Additional Description of that we want to enter the data for and applicable to this person ProfileProfileItemVOSourceTypeSOURCE_TYPEPVAL006VARCHARNo300NoProfileProfileItemVOSourceKey1SOURCE_KEY1PVAL007NUMERICNo180NoProfileProfileItemVOSourceKey2SOURCE_KEY2PVAL008NUMERICNo180NoProfileProfileItemVOSourceKey3SOURCE_KEY3PVAL009NUMERICNo180NoProfileProfileItemVOSourceIdSOURCE_IDPVAL010NUMERICNo180NoProfileProfileItemVOMandatoryMANDATORYPVAL011VARCHARNo300NoProfileProfileItemVOItemText2403ITEM_TEXT240_3PVAL012VARCHARNo2400NoProfileProfileItemVOItemText2401ITEM_TEXT240_1PVAL013VARCHARNo2400Noeg Major for this degree
ProfileProfileItemVOItemText2402ITEM_TEXT240_2PVAL014VARCHARNo2400NoProfileProfileItemVORatingModelId2RATING_MODEL_ID2PVAL015USRKEYNo360NoProfileProfileItemVORatingModelId3RATING_MODEL_ID3PVAL016USRKEYNo360NoProfileProfileItemVOQualifierId1QUALIFIER_ID1PVAL017USRKEYNo360NoProfileProfileItemVORatingLevelId2RATING_LEVEL_ID2PVAL018USRKEYNo360NoProfileProfileItemVORatingModelId1RATING_MODEL_ID1PVAL019USRKEYNo360NoProfileProfileItemVOItemText2407ITEM_TEXT240_7PVAL020VARCHARNo2400NoProfileProfileItemVORatingLevelId1RATING_LEVEL_ID1PVAL021USRKEYNo360NoProfileProfileItemVOItemText2406ITEM_TEXT240_6PVAL022VARCHARNo2400NoAverage Grade ProfileProfileItemVOImportanceIMPORTANCEPVAL023VARCHARNo300NoProfileProfileItemVORatingLevelId3RATING_LEVEL_ID3PVAL024USRKEYNo360NoProfileProfileItemVOItemText2404ITEM_TEXT240_4PVAL025VARCHARNo2400NoProfileProfileItemVOQualifierId2QUALIFIER_ID2PVAL026USRKEYNo360NoProfileProfileItemVOItemText2405ITEM_TEXT240_5PVAL027VARCHARNo2400NoProfileProfileItemVOParentProfileItemIdPARENT_PROFILE_ITEM_IDPVAL028USRKEYNo360NoProfileProfileItemVOInterestLevelINTEREST_LEVELPVAL029VARCHARNo300NoProfileProfileItemVOItemText2408ITEM_TEXT240_8PVAL030VARCHARNo2400NoProfileProfileItemVOItemText2409ITEM_TEXT240_9PVAL031VARCHARNo2400NoProfileProfileItemVOItemText24010ITEM_TEXT240_10PVAL032VARCHARNo2400NoProfileProfileItemVOItemText24011ITEM_TEXT240_11PVAL033VARCHARNo2400NoProfileProfileItemVOItemText24012ITEM_TEXT240_12PVAL034VARCHARNo2400NoProfileProfileItemVOItemText24013ITEM_TEXT240_13PVAL035VARCHARNo2400NoProfileProfileItemVOItemText24014ITEM_TEXT240_14PVAL036VARCHARNo2400NoProfileProfileItemVOItemText24015ITEM_TEXT240_15PVAL037VARCHARNo2400NoProfileProfileItemVOItemText20001ITEM_TEXT2000_1PVAL038VARCHARNo20000NoProfileProfileItemVOItemText20002ITEM_TEXT2000_2PVAL039VARCHARNo20000NoProfileProfileItemVOItemText20003ITEM_TEXT2000_3PVAL040VARCHARNo20000NoProfileProfileItemVOItemText20004ITEM_TEXT2000_4PVAL041VARCHARNo20000NoProfileProfileItemVOItemText20005ITEM_TEXT2000_5PVAL042VARCHARNo20000NoProfileProfileItemVOItemText301ITEM_TEXT30_1PVAL043VARCHARNo300NoProfileProfileItemVOItemText302ITEM_TEXT30_2PVAL044VARCHARNo300NoProfileProfileItemVOItemText303ITEM_TEXT30_3PVAL045VARCHARNo300NoProfileProfileItemVOItemText304ITEM_TEXT30_4PVAL046VARCHARNo300NoProfileProfileItemVOItemText305ITEM_TEXT30_5PVAL047VARCHARNo300NoProfileProfileItemVOItemText306ITEM_TEXT30_6PVAL048VARCHARNo300NoProfileProfileItemVOItemText307ITEM_TEXT30_7PVAL049VARCHARNo300NoProfileProfileItemVOItemText308ITEM_TEXT30_8PVAL050VARCHARNo300NoProfileProfileItemVOItemText309ITEM_TEXT30_9PVAL051VARCHARNo300NoProfileProfileItemVOItemText3010ITEM_TEXT30_10PVAL052VARCHARNo300NoProfileProfileItemVOItemText3011ITEM_TEXT30_11PVAL053VARCHARNo300NoProfileProfileItemVOItemText3012ITEM_TEXT30_12PVAL054VARCHARNo300NoProfileProfileItemVOItemText3013ITEM_TEXT30_13PVAL055VARCHARNo300NoProfileProfileItemVOItemText3014ITEM_TEXT30_14PVAL056VARCHARNo300NoProfileProfileItemVOItemText3015ITEM_TEXT30_15PVAL057VARCHARNo300NoProfileProfileItemVOItemDate1ITEM_DATE_1PDATE001DATENo00NoProfileProfileItemVOItemDate2ITEM_DATE_2PDATE002DATENo00NoProfileProfileItemVOItemDate3ITEM_DATE_3PDATE003DATENo00NoProfileProfileItemVOItemDate4ITEM_DATE_4PDATE004DATENo00NoProfileProfileItemVOItemDate5ITEM_DATE_5PDATE005DATENo00NoProfileProfileItemVOItemDate6ITEM_DATE_6PDATE006DATENo00NoProfileProfileItemVOItemDate7ITEM_DATE_7PDATE007DATENo00NoProfileProfileItemVOItemDate8ITEM_DATE_8PDATE008DATENo00NoProfileProfileItemVOItemDate9ITEM_DATE_9PDATE009DATENo00NoProfileProfileItemVOItemDate10ITEM_DATE_10PDATE010DATENo00NoProfileProfileItemVOItemNumber1ITEM_NUMBER_1PVAL058USRKEYNo360NoProfileProfileItemVOItemNumber2ITEM_NUMBER_2PVAL059USRKEYNo360NoProfileProfileItemVOItemNumber3ITEM_NUMBER_3PVAL060USRKEYNo360NoProfileProfileItemVOItemNumber4ITEM_NUMBER_4PVAL061USRKEYNo360NoProfileProfileItemVOItemNumber5ITEM_NUMBER_5PVAL062USRKEYNo360NoProfileProfileItemVOItemNumber6ITEM_NUMBER_6PVAL063USRKEYNo360NoProfileProfileItemVOItemNumber7ITEM_NUMBER_7PVAL064USRKEYNo360NoProfileProfileItemVOItemNumber8ITEM_NUMBER_8PVAL065USRKEYNo360Noeg Year the Degree was acquired
ProfileProfileItemVOItemNumber9ITEM_NUMBER_9PVAL066USRKEYNo360Noeg GUID from Key Map Reference table corresponding to OBJECT_NAME = ESTABLISHMENT_VO and Additional Description of from where the Person obtained the degree ProfileProfileItemVOItemNumber10ITEM_NUMBER_10PVAL067USRKEYNo360NoProfileProfileItemVOItemDecimal1ITEM_DECIMAL_1PVAL068NUMERICNo152NoProfileProfileItemVOItemDecimal2ITEM_DECIMAL_2PVAL069NUMERICNo152NoProfileProfileItemVOItemDecimal3ITEM_DECIMAL_3PVAL070NUMERICNo152NoProfileProfileItemVOItemDecimal4ITEM_DECIMAL_4PVAL071NUMERICNo152NoProfileProfileItemVOItemDecimal5ITEM_DECIMAL_5PVAL072NUMERICNo152NoProfileProfileItemVODateFromDATE_FROMPDATE011DATENo00YesLeave Blank, it will default to SYSDATEProfileProfileItemVODateToDATE_TOPDATE012DATENo00NoLeave BlankProfileProfileItemVOCountryIdCOUNTRY_IDPVAL074NUMERICNo180NoProfileProfileItemVOStateProvinceIdSTATE_PROVINCE_IDPVAL073NUMERICNo180NoRatingModelRatingLevelVORatingLevelIdRATING_LEVEL_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectRatingModelRatingLevelVORatingModelIdRATING_MODEL_IDPVAL002USRKEYNo360YesReference value used to identify Rating Model (RatingModelID in RatingModelVO object)RatingModelRatingLevelVOBusinessGroupIdBUSINESS_GROUP_IDPVAL003Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICYes360YesLeave blank - it will be set to the Enterprise of the invoking userRatingModelRatingLevelVORatingLevelCodeRATING_LEVEL_CODEPVAL004VARCHARNo300YesRatingModelRatingLevelVORatingDescriptionRATING_DESCRIPTIONPVAL005VARCHARNo20000YesRatingModelRatingLevelVORatingShortDescrRATING_SHORT_DESCRPVAL006VARCHARNo2400YesRatingModelRatingLevelVOReviewRatingDescrREVIEW_RATING_DESCRPVAL007VARCHARNo40000NoRatingModelRatingLevelVODateFromDATE_FROMPDATE001DATENo00YesRatingModelRatingLevelVODateToDATE_TOPDATE002DATENo00NoRatingModelRatingLevelVOCareerStrDevCAREER_STR_DEVPVAL008VARCHARNo300NoRatingModelRatingLevelVOReviewPointsREVIEW_POINTSPVAL009NUMERICNo30NoRatingModelRatingLevelVONumericRatingNUMERIC_RATINGPVAL010NUMERICNo52NoRatingModelRatingLevelVOFromPointsFROM_POINTSPVAL011NUMERICNo30NoRatingModelRatingLevelVOToPointsTO_POINTSPVAL012NUMERICNo30NoRatingModelRatingLevelVOStarRatingSTAR_RATINGPVAL013NUMERICNo52NoRatingModelRatingLevelVOMinRatingDistributionMIN_RATING_DISTRIBUTIONPVAL014NUMERICNo52NoRatingModelRatingLevelVOMaxRatingDistributionMAX_RATING_DISTRIBUTIONPVAL015NUMERICNo52NoRatingModelRatingLevelVOModuleIdMODULE_IDPVAL016NUMERICNo180NoRatingModelRatingModelVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICYes360YesLeave blank - it will be set to the Enterprise of the invoking userRatingModelRatingModelVODateFromDATE_FROMPDATE001DATENo00YesRatingModelRatingModelVODateToDATE_TOPDATE002DATENo00NoRatingModelRatingModelVODistributionThresholdDISTRIBUTION_THRESHOLDPVAL003NUMERICNo180NoRatingModelRatingModelVOModuleIdMODULE_IDPVAL004NUMERICNo180NoRatingModelRatingModelVORatingDescriptionRATING_DESCRIPTIONPVAL005VARCHARNo40000NoRatingModelRatingModelVORatingModelCodeRATING_MODEL_CODEPVAL006VARCHARNo300YesRatingModelRatingModelVORatingModelIdRATING_MODEL_IDPVAL001USRKEYYes360YesPrimary key - use unique identifier of objectRatingModelRatingModelVORatingNameRATING_NAMEPVAL007VARCHARNo2400YesSalarySalaryComponentVOBusinessGroupIdBUSINESS_GROUP_IDPVAL022Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank , No used in CompensationSalarySalaryComponentVOChangeAmountCHANGE_AMOUNTPVAL023NUMERICNo186NoSalarySalaryComponentVOChangePercentageCHANGE_PERCENTAGEPVAL024NUMERICNo186NoChange Percentage should be calculated and captured correctly from SOURCE as it will be calculated by Oracle Fusion and displayed in the Adjustments to verifySalarySalaryComponentVOComponentApprovedCOMPONENT_APPROVEDPVAL025VARCHARNo300NoY or NSalarySalaryComponentVOComponentReasonCodeCOMPONENT_REASON_CODEPVAL026VARCHARNo300YesValidated against CMP_PROPOSAL_REASON lookupSalarySalaryComponentVOSalaryComponentIdSALARY_COMPONENT_IDPVAL027USRKEYYes360YesPrimary key - use unique identifier of objectSalarySalaryComponentVOSalaryIdSALARY_IDPVAL028USRKEYNo360YesReference value used to identify Salary (SalaryID in SalaryVO object)SalarySalaryVOActionIdACTION_IDPVAL001USRKEYNo360NoThe GUID reference to the Action extracted from FusionSalarySalaryVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL002NUMERICNo180NoEnter 0SalarySalaryVOActionReasonIdACTION_REASON_IDPVAL003USRKEYNo360NoThe GUID reference to the Action Reason extracted from FusionSalarySalaryVOAssignmentIdASSIGNMENT_IDPVAL004USRKEYNo360YesReference value used to identify Assignment (AssignmentID in AssignmentVO object)SalarySalaryVOBusinessGroupIdBUSINESS_GROUP_IDPVAL026Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank , No used in CompensationSalarySalaryVODateFromDATE_FROMPDATE001DATENo00YesSalarySalaryVODateToDATE_TOPDATE002DATENo00YesSalarySalaryVOElementEntryIdELEMENT_ENTRY_IDPVAL027USRKEYNo360NoLeave blankSalarySalaryVOMultipleComponentsMULTIPLE_COMPONENTSPVAL028VARCHARNo300YesY or NSalarySalaryVONextSalReviewDateNEXT_SAL_REVIEW_DATEPDATE003DATENo00Nonot required field but if we pass it then it should be greater than the DATE_FROM value for that Salary Change recordSalarySalaryVOSalaryAmountSALARY_AMOUNTPVAL029NUMERICNo186YesSalary amount is the total of the Salary components + previous salarySalarySalaryVOSalaryApprovedSALARY_APPROVEDPVAL030VARCHARNo300YesY or NSalarySalaryVOSalaryBasisIdSALARY_BASIS_IDPVAL031USRKEYNo360YesReference value used to identify Salary Basis (SalaryBasisID in SalaryBasisVO object)SalarySalaryVOSalaryIdSALARY_IDPVAL032USRKEYYes360YesPrimary key - use unique identifier of objectSalaryBasisSalaryBasisVOSalaryBasisIdSALARY_BASIS_IDPVAL010USRKEYYes360YesPrimary key - use unique identifier of objectSalaryBasisSalaryBasisVOBusinessGroupIdBUSINESS_GROUP_IDPVAL001Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank , No used in CompensationSalaryBasisSalaryBasisVODescriptionDESCRIPTIONPVAL003VARCHARNo3000NoNo Longer UsedSalaryBasisSalaryBasisVOElementTypeIdELEMENT_TYPE_IDPVAL004USRKEYNo360YesThe GUID reference to the Element Type extracted from FusionSalaryBasisSalaryBasisVOComponentUsageCOMPONENT_USAGEPVAL002VARCHARNo300YesSalaryBasisSalaryBasisVOGradeRateIdGRADE_RATE_IDPVAL005USRKEYNo360NoReference value used to identify Grade Rate (GradeRateID in GradeRateVO object)SalaryBasisSalaryBasisVOInputValueIdINPUT_VALUE_IDPVAL006USRKEYNo360YesThe GUID reference to the Element Type's Input Value extracted from FusionSalaryBasisSalaryBasisVOLegalEntityIdLEGAL_ENTITY_IDPVAL007Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDUSRKEYNo360YesNo Longer UsedSalaryBasisSalaryBasisVOSalaryAnnualizationFactorSALARY_ANNUALIZATION_FACTORPVAL008NUMERICNo186NoSalaryBasisSalaryBasisVOSalaryBasisCodeSALARY_BASIS_CODEPVAL009VARCHARNo300YesANNUAL, MONTHLY, HOURLYSalaryBasisSalaryBasisVOSalaryBasisNameSALARY_BASIS_NAMEPVAL011VARCHARNo800YesSalaryBasisSalaryBasisVOLegislativeDataGroupIdLEGISLATIVE_DATA_GROUP_IDPVAL012USRKEYNo360YesVisaVisaVOVisaPermitIdVISA_PERMIT_IDUSRKEYYesYesPrimary key - use unique identifier of objectVisaVisaVOEffectiveStartDateEFFECTIVE_START_DATEDATEYesYesStart date of the date effective record (YYYY-MM-DD)VisaVisaVOEffectiveEndDateEFFECTIVE_END_DATEDATEYesYesEnd date of the date effective record (YYYY-MM-DD)VisaVisaVOPersonIdPERSON_IDForeign KeyPersonVO.PersonIdNUMERICNoYesReference value used to identify Person (PersonID in PersonVO object): Person must be exist on the EffectiveStartDateVisaVisaVOBusinessGroupIdBUSINESS_GROUP_IDForeign KeyNUMERICNoYesLeave blank - it will be set to the Enterprise of the invoking userVisaVisaVOLegislationCodeLEGISLTATION_CODETable LookupVARCHARNoYesValidated against TERRITORY_CODE in TerritoriesVisaVisaVOVisaPermitNumberVISA_PERMIT_NUMBERVARCHARNoNoVisaVisaVOVisaPermitTypeVISA_PERMIT_TYPEVARCHARNoNoValidated against PER_VISA_PERMIT_TYPE LookupVisaVisaVOVisaPermitStatusVISA_PERMIT_STATUSVARCHARNoNoValidated against PER_VISA_PERMIT_STATUS LookupVisaVisaVOVisaPermitStatusDateVISA_PERMIT_STATUS_DATEDATENoNoVisaVisaVOVisaPermitCategoryVISA_PERMIT_CATEGORYVARCHARNoNoValidated against the extended look up code for PER_VISA_PERMIT_TYPE VisaVisaVOIssueDateISSUE_DATEDATENoNoVisaVisaVOExpirationDateEXPIRATION_DATEDATENoNoVisaVisaVOEntryDateENTRY_DATEDATENoNoVisaVisaVOCurrentVisaPermitCURRENT_VISA_PERMITVARCHARNoNoY or NVisaVisaVOIssuingAuthorityISSUING_AUTHORITYVARCHARNoNoVisaVisaVOIssuingCountryISSUING_COUNTRYTable LookupVARCHARNoNoValidated against TERRITORY_CODE in TerritoriesVisaVisaVOIssuingLocationISSUING_LOCATIONVARCHARNoNoVisaVisaVOProfessionPROFESSIONVARCHARNoNoWorkRelationshipAssignmentSupervisorVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL001NUMERICNo180NoEnter 0ACTION_OCCURRENCE_IDWorkRelationshipAssignmentSupervisorVOAssignmentIdASSIGNMENT_IDPVAL002USRKEYNo360YesReference value used to identify Assignment (AssignmentID in AssignmentVO object)ASSIGNMENT_IDWorkRelationshipAssignmentSupervisorVOAssignmentSupervisorIdASSIGNMENT_SUPERVISOR_IDPVAL003USRKEYYes360YesPrimary key - use unique identifier of objectASSIGNMENT_SUPERVISOR_IDWorkRelationshipAssignmentSupervisorVOBusinessGroupIdBUSINESS_GROUP_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userBUSINESS_GROUP_IDWorkRelationshipAssignmentSupervisorVOEffectiveEndDateEFFECTIVE_END_DATEPDATE001DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)EFFECTIVE_END_DATEWorkRelationshipAssignmentSupervisorVOEffectiveStartDateEFFECTIVE_START_DATEPDATE002DATEYes00YesStart date of the date effective record (YYYY-MM-DD)EFFECTIVE_START_DATEWorkRelationshipAssignmentSupervisorVOManagerAssignmentIdMANAGER_ASSIGNMENT_IDPVAL005USRKEYNo360YesReference value used to identify Manager's Assignment (AssignmentID in AssignmentVO object)MANAGER_ASSIGNMENT_IDWorkRelationshipAssignmentSupervisorVOManagerIdMANAGER_IDPVAL006USRKEYNo360YesReference value used to identify Manager (PersonID in PersonVO object), Person must be exist on the EffectiveStartDateMANAGER_IDWorkRelationshipAssignmentSupervisorVOManagerTypeMANAGER_TYPEPVAL007VARCHARNo300YesValidated against PER_SUPERVISOR_TYPE lookupMANAGER_TYPEWorkRelationshipAssignmentSupervisorVOPersonIdPERSON_IDPVAL008Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDatePERSON_IDWorkRelationshipAssignmentSupervisorVOPrimaryFlagPRIMARY_FLAGPVAL009VARCHARNo300YesY or NFT_ALTERNATE_KEYWorkRelationshipAssignmentSupervisorVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateWorkRelationshipAssignmentSupervisorVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateWorkRelationshipAssignmentVOActionCodeACTION_CODEPVAL001VARCHARNo300Yesuse seeded action code or action code from ActionVo WorkRelationshipAssignmentVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL002NUMERICNo180NoEnter 0WorkRelationshipAssignmentVOAssignmentIdASSIGNMENT_IDPVAL003USRKEYYes360YesPrimary key - use unique identifier of objectWorkRelationshipAssignmentVOAssignmentNameASSIGNMENT_NAMEPVAL004VARCHARNo800NoWorkRelationshipAssignmentVOAssignmentNumberASSIGNMENT_NUMBERPVAL005VARCHARNo300NoWorkRelationshipAssignmentVOAssignmentSequenceASSIGNMENT_SEQUENCEPVAL006NUMERICNo180YesShould NOT be 1 for Rehires. This should either be passed as NULL or should be the count of the assignments +1 for the PersonWorkRelationshipAssignmentVOAssignmentStatusTypeASSIGNMENT_STATUS_TYPEPVAL007VARCHARNo300YesDenormalised value of the Assignment Status Type corresponding to the Assignment Status Type IdWorkRelationshipAssignmentVOAssignmentStatusTypeIdASSIGNMENT_STATUS_TYPE_IDPVAL008USRKEYNo360YesThe GUID reference to the Assignment Status Type extracted from FusionWorkRelationshipAssignmentVOAssignmentTypeASSIGNMENT_TYPEPVAL009VARCHARNo300YesE (Employee) or C (Contingent Worker)WorkRelationshipAssignmentVOAutoEndFlagAUTO_END_FLAGPVAL010VARCHARNo300YesY or NWorkRelationshipAssignmentVOBargainingUnitCodeBARGAINING_UNIT_CODEPVAL011VARCHARNo300NoValidated against BARGAINING_UNIT_CODE lookupWorkRelationshipAssignmentVOBillingTitleBILLING_TITLEPVAL012VARCHARNo300NoWorkRelationshipAssignmentVOBusinessGroupIdBUSINESS_GROUP_IDPVAL013Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userWorkRelationshipAssignmentVOBusinessUnitIdBUSINESS_UNIT_IDPVAL014USRKEYNo360YesReference value used to identify Business Unit (BusinessUnitID in BusinessUnitVO object)WorkRelationshipAssignmentVODateProbationEndDATE_PROBATION_ENDPDATE001DATENo00NoWorkRelationshipAssignmentVODutiesTypeDUTIES_TYPEPVAL020VARCHARNo300NoValidated against the PER_DUTIES_TYPE lookupWorkRelationshipAssignmentVOEffectiveEndDateEFFECTIVE_END_DATEPDATE002DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)WorkRelationshipAssignmentVOEffectiveLatestChangeEFFECTIVE_LATEST_CHANGEPVAL021VARCHARYes300YesWorkRelationshipAssignmentVOEffectiveSequenceEFFECTIVE_SEQUENCEPVAL022NUMERICYes360YesStarts at 1. Indicator of the sequence of date effective change within a dayWorkRelationshipAssignmentVOEffectiveStartDateEFFECTIVE_START_DATEPDATE003DATEYes00YesStart date of the date effective record (YYYY-MM-DD). >= DATE_START of WorkRelationship and < Actual Termination DateWorkRelationshipAssignmentVOEmployeeCategoryEMPLOYEE_CATEGORYPVAL023VARCHARNo300NoValidated against the EMPLOYEE_CATG lookupWorkRelationshipAssignmentVOEmploymentCategoryEMPLOYMENT_CATEGORYPVAL024VARCHARNo300NoValidated against the EMP_CAT lookupWorkRelationshipAssignmentVOExpenseCheckSendToAddressEXPENSE_CHECK_ADDRESSPVAL026VARCHARNo300NoWorkRelationshipAssignmentVOFrequencyFREQUENCYPVAL027VARCHARNo300NoValidated against the FREQUENCY lookupWorkRelationshipAssignmentVOGradeIdGRADE_IDPVAL028USRKEYNo360NoReference value used to identify Grade (GradeID in GradeVO object)WorkRelationshipAssignmentVOHourlySalariedCodeHOURLY_SALARIED_CODEPVAL030VARCHARNo300NoValidated against the HOURLY_SALARIED_CODE lookupWorkRelationshipAssignmentVOInternalBuildingINTERNAL_BUILDINGPVAL031VARCHARNo450NoWorkRelationshipAssignmentVOInternalFloorINTERNAL_FLOORPVAL032VARCHARNo450NoWorkRelationshipAssignmentVOInternalLocationINTERNAL_LOCATIONPVAL033VARCHARNo800NoWorkRelationshipAssignmentVOInternalMailstopINTERNAL_MAILSTOPPVAL034VARCHARNo450NoWorkRelationshipAssignmentVOInternalOfficeNumberINTERNAL_OFFICE_NUMBERPVAL035VARCHARNo450NoWorkRelationshipAssignmentVOJobIdJOB_IDPVAL036USRKEYNo360NoReference value used to identify Job (JobID in JobVO object)WorkRelationshipAssignmentVOJobPostSourceNameJOB_POST_SOURCE_NAMEPVAL037VARCHARNo2400NoWorkRelationshipAssignmentVOLabourUnionMemberFlagLABOUR_UNION_MEMBER_FLAGPVAL038VARCHARNo300NoY or NWorkRelationshipAssignmentVOLegalEntityIdLEGAL_ENTITY_IDPVAL039Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDUSRKEYNo360YesThe GUID reference to the Legal Entity extracted from FusionWorkRelationshipAssignmentVOLegislationCodeLEGISLATION_CODEPVAL040Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo1500YesWorkRelationshipAssignmentVOLinkageTypeLINKAGE_TYPEPVAL041VARCHARNo300NoValidated against the PER_LINKAGE_TYPE lookupWorkRelationshipAssignmentVOLocationIdLOCATION_IDPVAL042USRKEYNo360NoReference value used to identify Location (LocationID in LocationVO object)WorkRelationshipAssignmentVOManagerFlagMANAGER_FLAGPVAL043VARCHARNo300NoY or NWorkRelationshipAssignmentVONormalHoursNORMAL_HOURSPVAL044NUMERICNo183NoWorkRelationshipAssignmentVONoticePeriodNOTICE_PERIODPVAL045NUMERICNo180NoWorkRelationshipAssignmentVONoticePeriodUomNOTICE_PERIOD_UOMPVAL046VARCHARNo300NoValidated against the QUALIFYING_UNITS lookupWorkRelationshipAssignmentVOOrganizationIdORGANIZATION_IDPVAL047USRKEYNo360NoReference value used to identify Department (DepartmentID in DepartmentVO object)WorkRelationshipAssignmentVOPeriodOfServiceIdPERIOD_OF_SERVICE_IDPVAL050USRKEYNo360YesReference value used to identify Period of Service (PeriodOfServiceID in WorkRelationshipVO object)WorkRelationshipAssignmentVOPersonIdPERSON_IDPVAL051Foreign KeyIdPersonVO.PersonIdUSRKEYNo360YesReference value used to identify Person (PersonID in PersonVO object), Person must be exist on the EffectiveStartDateWorkRelationshipAssignmentVOPersonTypeIdPERSON_TYPE_IDPVAL052Foreign KeyIdPER_PERSON_TYPES.PERSON_TYPE_IDUSRKEYNo360NoThe GUID reference to thePerson Type extracted from FusionWorkRelationshipAssignmentVOPositionIdPOSITION_IDPVAL055USRKEYNo360NoReference value used to identify Position (PositionID in PositionVO object)WorkRelationshipAssignmentVOPositionOverrideFlagPOSITION_OVERRIDE_FLAGPVAL056VARCHARNo300YesWorkRelationshipAssignmentVOPrimaryAssignmentFlagPRIMARY_ASSIGNMENT_FLAGPVAL058VARCHARNo300NoY or NWorkRelationshipAssignmentVOPrimaryFlagPRIMARY_FLAGPVAL059VARCHARNo300YesY or NWorkRelationshipAssignmentVOPrimaryWorkRelationFlagPRIMARY_WORK_RELATION_FLAGPVAL060VARCHARNo300YesY or NWorkRelationshipAssignmentVOPrimaryWorkTermsFlagPRIMARY_WORK_TERMS_FLAGPVAL061VARCHARNo300NoNullWorkRelationshipAssignmentVOProbationPeriodPROBATION_PERIODPVAL062NUMERICNo222NoWorkRelationshipAssignmentVOProbationUnitPROBATION_UNITPVAL063VARCHARNo300NoValidated against the QUALIFYING_UNITS lookupWorkRelationshipAssignmentVOProjectTitlePROJECT_TITLEPVAL064VARCHARNo800NoWorkRelationshipAssignmentVOProjectedAssignmentEndPROJECTED_ASSIGNMENT_ENDPDATE004DATENo00NoWorkRelationshipAssignmentVOProposedWorkerTypePROPOSED_WORKER_TYPEPVAL065VARCHARNo300NoWorkRelationshipAssignmentVOReasonCodeREASON_CODEPVAL066VARCHARNo300NoWorkRelationshipAssignmentVORecordCreatorRECORD_CREATORPVAL067VARCHARNo300NoWorkRelationshipAssignmentVORetirementAgeRETIREMENT_AGEPVAL068NUMERICNo180NoWorkRelationshipAssignmentVORetirementDateRETIREMENT_DATEPDATE005DATENo00NoWorkRelationshipAssignmentVOSalReviewPeriodSAL_REVIEW_PERIODPVAL069NUMERICNo180NoWorkRelationshipAssignmentVOSalReviewPeriodFrequencySAL_REVIEW_PERIOD_FREQUENCYPVAL070VARCHARNo300NoValidated against the FREQUENCY lookupWorkRelationshipAssignmentVOSourceTypeSOURCE_TYPEPVAL072VARCHARNo300NoWorkRelationshipAssignmentVOStepEntryDateSTEP_ENTRY_DATEPDATE006DATENo00NoWorkRelationshipAssignmentVOSystemPersonTypeSYSTEM_PERSON_TYPEPVAL074Lookup TypeSYSTEM_PERSON_TYPEVARCHARNo300NoApplicant, Beneficiary, Contingent Worker, Domestic Partner, etc..WorkRelationshipAssignmentVOTimeNormalFinishTIME_NORMAL_FINISHPVAL076VARCHARNo50NoWorkRelationshipAssignmentVOTimeNormalStartTIME_NORMAL_STARTPVAL077VARCHARNo50NoWorkRelationshipAssignmentVOVendorAssignmentNumberVENDOR_ASSIGNMENT_NUMBERPVAL078VARCHARNo300NoWorkRelationshipAssignmentVOVendorEmployeeNumberVENDOR_EMPLOYEE_NUMBERPVAL079VARCHARNo300NoWorkRelationshipAssignmentVOWorkAtHomeWORK_AT_HOMEPVAL082VARCHARNo300NoY or NWorkRelationshipAssignmentVOWorkTermsAssignmentIdWORK_TERMS_ASSIGNMENT_IDPVAL083USRKEYNo360NoReference value used to identify Work Terms (WorkTermID in WorkTermsVO object)WorkRelationshipAssignmentVOFreezeStartDateFREEZE_START_DATEPDATE007DATENo00YesEnd of Time (4712-12-31)WorkRelationshipAssignmentVOFreezeUntilDateFREEZE_UNTIL_DATEPDATE008DATENo00YesStart of Time (1951-01-01)WorkRelationshipAssignmentVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateWorkRelationshipAssignmentVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateWorkRelationshipAssignmentWorkMeasureVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL001NUMERICNo180NoEnter 0WorkRelationshipAssignmentWorkMeasureVOAddsToBudgetADDS_TO_BUDGETPVAL002VARCHARNo300YesY or NWorkRelationshipAssignmentWorkMeasureVOAssignWorkMeasureIdASSIGN_WORK_MEASURE_IDPVAL003USRKEYYes360YesPrimary key - use unique identifier of objectWorkRelationshipAssignmentWorkMeasureVOAssignmentIdASSIGNMENT_IDPVAL004USRKEYNo360YesReference value used to identify Assignment (AssignmentID in AssignmentVO object)WorkRelationshipAssignmentWorkMeasureVOBusinessGroupIdBUSINESS_GROUP_IDPVAL005Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userWorkRelationshipAssignmentWorkMeasureVOEffectiveEndDateEFFECTIVE_END_DATEPDATE001DATEYes00YesEnd date of the date effective record (YYYY-MM-DD)WorkRelationshipAssignmentWorkMeasureVOEffectiveStartDateEFFECTIVE_START_DATEPDATE002DATEYes00YesStart date of the date effective record (YYYY-MM-DD)WorkRelationshipAssignmentWorkMeasureVOUnitUNITPVAL006VARCHARNo300YesValidated against BUDGET_MEASUREMENT_TYPE lookup (i.e. HEAD, FTE)WorkRelationshipAssignmentWorkMeasureVOValueVALUEPVAL007NUMERICNo255YesMust be >= 0WorkRelationshipAssignmentWorkMeasureVOLogical Start DateLSDVARCHARNo00NoIf "Y" then EffectiveStartDate becomes Logical Start DateWorkRelationshipAssignmentWorkMeasureVOLogical End DataLEDVARCHARNo00NoIf "Y" then EffectiveEndDate becomes Logical End DateWorkRelationshipWorkRelationshipVOAcceptedTerminationDateACCEPTED_TERMINATION_DATEPDATE001DATENo00NoCannot be used in the intial Work Relationship recordWorkRelationshipWorkRelationshipVOActionOccurrenceIdACTION_OCCURRENCE_IDPVAL001NUMERICNo180NoEnter 0WorkRelationshipWorkRelationshipVOActualTerminationDateACTUAL_TERMINATION_DATEPDATE002DATENo00NoCannot be used in the intial Work Relationship recordWorkRelationshipWorkRelationshipVOAdjustedSvcDateADJUSTED_SVC_DATEPDATE003DATENo00NoWorkRelationshipWorkRelationshipVOBusinessGroupIdBUSINESS_GROUP_IDPVAL002Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDNUMERICNo180YesLeave blank - it will be set to the Enterprise of the invoking userWorkRelationshipWorkRelationshipVODateEmployeeDataVerifiedDATE_EMPLOYEE_DATA_VERIFIEDPDATE004DATENo00NoWorkRelationshipWorkRelationshipVODateStartDATE_STARTPDATE005DATENo00YesWorkRelationshipWorkRelationshipVOFastPathEmployeeFAST_PATH_EMPLOYEEPVAL003VARCHARNo300YesY or NWorkRelationshipWorkRelationshipVOLastWorkingDateLAST_WORKING_DATEPDATE006DATENo00NoWorkRelationshipWorkRelationshipVOLegalEntityIdLEGAL_ENTITY_IDPVAL004Foreign KeyIdHR_ORGANIZATION_UNITS_F_TL.ORGANIZATION_IDUSRKEYNo360YesThe GUID reference to the Legal Entity extracted from FusionWorkRelationshipWorkRelationshipVOLegislationCodeLEGISLATION_CODEPVAL005Table LookupFND_TERRITORIES_B.TERRITORY_CODEVARCHARNo1500YesWorkRelationshipWorkRelationshipVONotifiedTerminationDateNOTIFIED_TERMINATION_DATEPDATE007DATENo00NoWorkRelationshipWorkRelationshipVOOnMilitaryServiceON_MILITARY_SERVICEPVAL006VARCHARNo300YesY or NWorkRelationshipWorkRelationshipVOOriginalDateOfHireORIGINAL_DATE_OF_HIREPDATE008DATENo00NoWorkRelationshipWorkRelationshipVOPeriodOfServiceIdPERIOD_OF_SERVICE_IDPVAL007USRKEYYes360YesPrimary key - use unique identifier of objectWorkRelationshipWorkRelationshipVOPeriodTypePERIOD_TYPEPVAL008VARCHARNo300YesE, C, N, PWorkRelationshipWorkRelationshipVOPersonIdPERSON_IDPVAL009Foreign