CREATE TABLE anc_per_abs_typ_lnkg (
    PER_ABS_TYP_LINKAGE_ID    NUMBER(18, 0),
    PER_ABSENCE_ENTRY_ID      NUMBER(18, 0)    NOT NULL,
    LINK_CHAIN_ID             NUMBER(18, 0),
    LNKD_PER_ABS_ENTRY_ID     NUMBER(18, 0)    NOT NULL,
    ENTERPRISE_ID             NUMBER(18, 0)    NOT NULL,
    LNKG_REASON               VARCHAR2(120),
    LNKG_REASON_ID            NUMBER(18, 0),
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    ABS_AGGREGATION_ID        NUMBER(18, 0),
    PER_ABS_TYP_LINKAGE_ID    NUMBER(18, 0),
    PER_ABSENCE_ENTRY_ID      NUMBER(18, 0)    NOT NULL,
    LNKD_PER_ABS_ENTRY_ID     NUMBER(18, 0)    NOT NULL,
    ENTERPRISE_ID             NUMBER(18, 0)    NOT NULL,
    LNKG_REASON               VARCHAR2(120),
    LNKG_REASON_ID            NUMBER(18, 0),
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    LINK_CHAIN_ID             NUMBER(18, 0),
    ABS_AGGREGATION_ID        NUMBER(18, 0),
    CONSTRAINT pk_anc_per_abs_typ_lnkg PRIMARY KEY (PER_ABS_TYP_LINKAGE_ID, PER_ABS_TYP_LINKAGE_ID)
);
