SCC_STG_MBRSHP

(SQL Table)
Index Back

Memberships

ACCOMPLISHMENTS Memberships Staging record

  • Parent record: SCC_STG_CONSTIT
  • # 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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: MEMBERSHIP_VW

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    5 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    6 MANDATE_BEGIN_DATE Date(10) DATE Mandate Begin Date
    7 MANDATE_END_DATE Date(10) DATE Mandate End Date
    8 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    9 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    10 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    11 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time