Table PERSON

DescriptionA human being, either alive or dead.

e.g. Brigitte Hyfra.
e.g. Marc Delbaere.
e.g. Will Smith.

Columns
PERSON_IDPERSON_ID
AGE_RANGEAGE_RANGE
AMOUNT_OWEDAMOUNT_OWED
ANCHOR_IDANCHOR_ID
BIRTH_DATEBIRTH_DATE
CURRENT_EMPLOYERCURRENT_EMPLOYER
CUSTOMER_STATUS_END_DATECUSTOMER_STATUS_END_DATE
CUSTOMER_STATUS_START_DATECUSTOMER_STATUS_START_DATE
CUSTOMER_STATUS_TENURECUSTOMER_STATUS_TENURE
DEATH_DATEDEATH_DATE
DESCRIPTIONDESCRIPTION
DISSOLUTION_DATEDISSOLUTION_DATE
DISTANCE_FROM_AGENTDISTANCE_FROM_AGENT
DISTANCE_FROM_HOME_TO_WORKDISTANCE_FROM_HOME_TO_WORK
DRINKING_HABIT_TYPEDRINKING_HABIT_TYPE
DRIVEN_DAYS_PER_WEEK_TO_WORKDRIVEN_DAYS_PER_WEEK_TO_WORK
DRIVING_LICENSE_ISSUE_DATEDRIVING_LICENSE_ISSUE_DATE
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
FIRST_HEAD_FORENAMEFIRST_HEAD_FORENAME
FIRST_HEAD_FULL_NAMEFIRST_HEAD_FULL_NAME
FIRST_HEAD_GIVEN_NAMEFIRST_HEAD_GIVEN_NAME
FIRST_HEAD_MIDDLE_NAMEFIRST_HEAD_MIDDLE_NAME
FIRST_HEAD_OCCUPATION_CODEFIRST_HEAD_OCCUPATION_CODE
FIRST_HEAD_OCCUPATION_NAMEFIRST_HEAD_OCCUPATION_NAME
FIRST_HEAD_PREFIX_TITLEFIRST_HEAD_PREFIX_TITLE
FIRST_HEAD_SUFFIX_TITLEFIRST_HEAD_SUFFIX_TITLE
FIRST_HEAD_SURNAMEFIRST_HEAD_SURNAME
FIRST_NAMEFIRST_NAME
FORENAMEFORENAME
FOUNDATION_DATEFOUNDATION_DATE
FULL_NAMEFULL_NAME
GIVEN_NAMEGIVEN_NAME
IDENTITY_CARD_NUMBERIDENTITY_CARD_NUMBER
LAST_NAMELAST_NAME
MARITAL_STATUS_DATEMARITAL_STATUS_DATE
MIDDLE_NAMEMIDDLE_NAME
MISSING_NOTIFICATION_DATEMISSING_NOTIFICATION_DATE
NATIONAL_INSURANCE_NUMBERNATIONAL_INSURANCE_NUMBER
NUMBER_OF_DEPENDENT_ADULTSNUMBER_OF_DEPENDENT_ADULTS
NUMBER_OF_DEPENDENT_CHILDRENNUMBER_OF_DEPENDENT_CHILDREN
NUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES
NUMBER_OF_MEMBERSNUMBER_OF_MEMBERS
OCCUPATION_NAMEOCCUPATION_NAME
OLDEST_DEPENDENT_ADULT_BIRTH_DATEOLDEST_DEPENDENT_ADULT_BIRTH_DATE
OLDEST_DEPENDENT_CHILD_BIRTH_DATEOLDEST_DEPENDENT_CHILD_BIRTH_DATE
PERSON_MINI_DIMENSION_IDPERSON_MINI_DIMENSION_ID
PERSONAL_SAVINGPERSONAL_SAVING
PREVIOUS_EMPLOYERPREVIOUS_EMPLOYER
PROPERTY_MARKET_VALUEPROPERTY_MARKET_VALUE
SALUTATIONSALUTATION
SECOND_HEAD_FORENAMESECOND_HEAD_FORENAME
SECOND_HEAD_FULL_NAMESECOND_HEAD_FULL_NAME
SECOND_HEAD_GIVEN_NAMESECOND_HEAD_GIVEN_NAME
SECOND_HEAD_MIDDLE_NAMESECOND_HEAD_MIDDLE_NAME
SECOND_HEAD_OCCUPATION_NAMESECOND_HEAD_OCCUPATION_NAME
SECOND_HEAD_PREFIX_TITLESECOND_HEAD_PREFIX_TITLE
SECOND_HEAD_SUFFIX_TITLESECOND_HEAD_SUFFIX_TITLE
SECOND_HEAD_SURNAMESECOND_HEAD_SURNAME
STATUS_DATESTATUS_DATE
SUFFIX_TITLESSUFFIX_TITLES
SURNAMESURNAME
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
YOUNGEST_DEPENDENT_ADULT_BIRTH_DATEYOUNGEST_DEPENDENT_ADULT_BIRTH_DATE
YOUNGEST_DEPENDENT_CHILD_BIRTH_DATEYOUNGEST_DEPENDENT_CHILD_BIRTH_DATE
ADDRESS_LAST_CHANGED_DATEADDRESS_LAST_CHANGED_DATE

Primary Key
PERSON_PKPERSON_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 PERSON_ID
DescriptionThe unique identifier of the Person
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AGE_RANGE
DescriptionCode indicating a range age. A Person is categorised into an age range which is derived from his date of birth.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AMOUNT_OWED
DescriptionThe amount owed by or to the party. If the debit creditor status is set to debtor, the party owes money to the modelled organisation (premium, loan). If the debit creditor status is set to creditor, the modelled organisation owes money to the party.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BIRTH_DATE
DescriptionThe birth date of the person.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_EMPLOYER
DescriptionThe name of the current employer of the person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_STATUS_END_DATE
DescriptionThe date on which the Person ends being in a Customer status. For example, the date on which the Person stopped being a customer of the modelled organisation.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_STATUS_START_DATE
DescriptionThe date on which a party starts being in a Customer status.
For example, the date on which a party first becomes a customer of the modelled organisation.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_STATUS_TENURE
DescriptionThe number of years that a household has been classified within its customer status.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEATH_DATE
DescriptionThe date of the person's death.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionThe textual representation of information or free form comments about a role player.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISSOLUTION_DATE
DescriptionThe date at which this organisation ceases to legally exist.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTANCE_FROM_AGENT
DescriptionDistance, in miles, from the primary agent of this household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTANCE_FROM_HOME_TO_WORK
DescriptionTravelling distance between home and work.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DRINKING_HABIT_TYPE
DescriptionCode indicating what kind of drinking habit a person has.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DRIVEN_DAYS_PER_WEEK_TO_WORK
DescriptionThe average number of days per week that this person drives to work
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DRIVING_LICENSE_ISSUE_DATE
DescriptionThe date on which this registration was issued by the relevant authority.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code used for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_FORENAME
DescriptionThe first head of Household's name normally preceding the surname and typically used in informal circumstances.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_FULL_NAME
DescriptionThe complete text of name used for identifying the first head of Household where the components of the name are unavailable or inapplicable. By default, the full name is a concatenation of the prefix title, the forename, the middle name, the surname and the suffix title.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_GIVEN_NAME
DescriptionGiven name of the first head of Household.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_MIDDLE_NAME
DescriptionThe additional names given to the first head of Household, usually at birth, and which appear sequentially between the forename and surname.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_OCCUPATION_CODE
DescriptionIndicates the occupation of the first head of Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_OCCUPATION_NAME
DescriptionName of the main current occupation performed by the first head of Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_PREFIX_TITLE
DescriptionThe honorifics or titles that precede the name when addressing the first head of Household in polite, somewhat formal circumstances.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_SUFFIX_TITLE
DescriptionThe titles, qualifications, or positions that follow the first head of Household's name when addressing formally or professionally, usually when writing.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_SURNAME
DescriptionThe part of the first head of Household's name arising from family identifications.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_NAME
DescriptionThe person's name, normally preceding the last name and typically used to refer to the person in informal circumstances. Synonym of person's forename.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORENAME
DescriptionThe person's name normally preceding the last name and typically used to refer to the person in informal circumstances.

e.g. John
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FOUNDATION_DATE
DescriptionThe date on which the organisation was founded or created.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_NAME
DescriptionThe complete aggregated name used for identifying a role player when the components of the name are unavailable or inapplicable.

e.g. Miss Mary Jane McSporran
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GIVEN_NAME
DescriptionThe abbreviated form of the person's first name.

e.g. Ed (for Edward)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDENTITY_CARD_NUMBER
DescriptionA code issued and used by the government to identify a Person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LAST_NAME
DescriptionThe part of a person's name arising from family identifications. Synonym of person's surname.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARITAL_STATUS_DATE
DescriptionThe date when the current marital status of the person became effective.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MIDDLE_NAME
DescriptionThe additional names given to a person, usually at birth, and which appear sequentially between the forename and surname.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MISSING_NOTIFICATION_DATE
DescriptionThe date at which the person was notified to be missing.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NATIONAL_INSURANCE_NUMBER
DescriptionA code used by the Social Services authorities to identify the person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DEPENDENT_ADULTS
DescriptionThe declared number of adults that are dependent from the household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DEPENDENT_CHILDREN
DescriptionThe declared number of children that are dependent from the household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_EMPLOYEES
DescriptionThe number of persons employed by the organisation.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_MEMBERS
DescriptionThe number of people being the members of this organisation. This number often is an approximate number, because the number of members may in general change over time without the modelled organisation being brought up to date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OCCUPATION_NAME
DescriptionName of the main current occupation performed by a person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OLDEST_DEPENDENT_ADULT_BIRTH_DATE
DescriptionThe birth date of the eldest dependent adult.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OLDEST_DEPENDENT_CHILD_BIRTH_DATE
DescriptionThe birth date of the eldest dependent child.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_MINI_DIMENSION_ID
DescriptionSoft link to Person mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSONAL_SAVING
DescriptionPersonal saving equals disposable personal income minus spending for consumption and interest payments. The personal saving rate is personal saving as a percentage of disposable personal income.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREVIOUS_EMPLOYER
DescriptionThe name of the previous employer of the person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROPERTY_MARKET_VALUE
DescriptionThe market value of the household's primary residential home.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SALUTATION
DescriptionThe preferred form of greeting to the person, particularly in written communication.

e.g. Dear Mr. Smith
e.g. Dear will
e.g. My Dear Miss Withers
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_FORENAME
DescriptionThe second head of Household's name normally preceding the surname and typically used to refer to him/her in informal circumstances.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_FULL_NAME
DescriptionThe complete text of name used for identifying the second head of Household where the components of the name are unavailable or inapplicable. By default, the full name is a concatenation of the prefix title, the forename, the middle name, the surname and the suffix title.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_GIVEN_NAME
DescriptionGiven name of the second head of Household.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_MIDDLE_NAME
DescriptionThe additional names given to the second head of Household, usually at birth, and which appear sequentially between the forename and surname.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_OCCUPATION_NAME
DescriptionName of the main current occupation performed by the second head of Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_PREFIX_TITLE
DescriptionThe honorifics or titles that precede the name when addressing the second head of Household in polite, somewhat formal circumstances.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_SUFFIX_TITLE
DescriptionThe titles, qualifications, or positions that follow the second head of Household's name when addressing formally or professionally, usually when writing.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_SURNAME
DescriptionThe part of the second head of Household's name arising from family identifications.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_DATE
DescriptionThe date on which the organisation's latest status became effective.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUFFIX_TITLES
DescriptionThe titles, qualifications, or positions that follow the person's name when addressing her formally or professionally, usually when writing.

e.g. FRCS
e.g. JR
e.g. LLB
e.g. MA
e.g. RN
e.g. SR
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SURNAME
DescriptionThe part of a person's name arising from family identifications.

e.g. Murphy
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YOUNGEST_DEPENDENT_ADULT_BIRTH_DATE
DescriptionThe birth date of the youngest dependent adult.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YOUNGEST_DEPENDENT_CHILD_BIRTH_DATE
DescriptionThe birth date of the youngest dependent child.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ADDRESS_LAST_CHANGED_DATE
DescriptionThe date of the person's death.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PERSON_PK
DescriptionThe unique identifier of the Person
MemberPERSON_ID [BIGINT]

Dependency Details

 AWM - Transformation