SCC_STG_CONSTIT

(SQL Table)
 Index Back

Constituent

Constituent Staging table used by the Transaction Manager

  • Parent Record Of SAD_PDL_HDR_STG SAD_PRS_CAR_STG SAD_STG_GEN_MAT SCC_CHSNAUS_STG SCC_CITZHST_STG SCC_HE_PERS_STG SCC_HE_PER_DER SCC_IWI_TBL_STG SCC_PDECAN_STG SCC_PER_NZL_STG SCC_STG_ACADHST SCC_STG_ADMIHD SCC_STG_ADMI_WK SCC_STG_CITZN SCC_STG_DISBLTY SCC_STG_DRV_LIC SCC_STG_EMAIL SCC_STG_EMG_CNT SCC_STG_EXTRACU SCC_STG_EXT_SKY SCC_STG_HON_AWD SCC_STG_LANG SCC_STG_LICCERT SCC_STG_MBRSHP SCC_STG_NAMES SCC_STG_NAME_WK SCC_STG_NID SCC_STG_PDE SCC_STG_PERSSA SCC_STG_PHONE SCC_STG_PRSDATU SCC_STG_PUBLIC SCC_STG_RELPREF SCC_STG_RES_SLF SCC_STG_RLSHIPS SCC_STG_SEVPOED SCC_STG_STD_CAR SCC_STG_TEST SCC_STG_VISPMTD SCC_STG_WORKEXP SCC_STG_WXPLANG SCC_YR12_AU_STG SSF_BNK_NLD_STG SSR_COR_NLD_STG SSR_EDU_NLD_STG SSR_INF_NLD_STG SSR_NAT_NLD_STG SSR_NME_NLD_STG SSR_SCL_NLD_STG SSR_STD_NLD_STG SSR_STG_CNRP_ST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    2 SUBMITTED Character(1) VARCHAR2(1) NOT NULL Submitted
    3 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    5 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

    Prompt Table: SCC_TRNSAC_DTLS

    6 BIRTHDATE Date(10) DATE Date of Birth
    7 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    8 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    9 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL

    10 DT_OF_DEATH Date(10) DATE Date of Death
    11 SCC_STG_STATUS Character(2) VARCHAR2(2) NOT NULL Staging Status
    AN=Add New ID
    CN=Cancelled
    LD=Loaded
    SA=New ID Created
    SI=Ignore
    SS=Suspended
    SU=ID Updated
    UE=Update ID
    VE=Error

    Default Value: LD

    12 SCC_STG_STS_DT Date(10) DATE SnL Staging Status Date
    13 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    15 SCC_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    16 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    17 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    18 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    19 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    20 SCC_UID_ADMIN Character(30) VARCHAR2(30) NOT NULL Created By
    21 SCC_ADMIN_MODE Character(1) VARCHAR2(1) NOT NULL Admin Mode