SCC_CM_ADDRESS

(SQL Table)
Index Back

CC_CM Address

SCC_CM_ADDRESS used by Inbound Constituent Web Service to get data from the HUB

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_UID Character(100) VARCHAR2(100) NOT NULL Universal Hub ID
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: ADDRESS_TYP_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    19 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    23 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    24 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    25 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    26 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    27 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    28 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.
    29 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.