SSR_HM_CAMPUS

(SQL Table)
Index Back

HEIMS Campus

HEIMS Campus transaction table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID
2 SSR_CORRELATION_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Correlation ID
3 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
4 SSR_MAP_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Map ID
5 SSR_MESSAGE_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Message ID
6 SSR_CMPUS_SUBURB Character(27) VARCHAR2(27) NOT NULL HEIMS Campus Suburb
7 SSR_CMPUS_CNTRY_CD Character(4) VARCHAR2(4) NOT NULL HEIMS Campus Country Code
8 SSR_CMPUS_POSTCODE Character(4) VARCHAR2(4) NOT NULL HEIMS Campus Postcode
9 SSR_DLOC_CODE Character(10) VARCHAR2(10) NOT NULL HEIMS Delivery Location Code
10 SSR_DLOC_ADDRESS Character(76) VARCHAR2(76) NOT NULL HEIMS Delivery Location Street Address
11 SSR_DLOC_SUBURB Character(48) VARCHAR2(48) NOT NULL HEIMS Delivery Location Suburb
12 SSR_DLOC_STATE Character(3) VARCHAR2(3) NOT NULL HEIMS Delivery Location State
13 SSR_DLOC_CNTRY_CD Character(4) VARCHAR2(4) NOT NULL HEIMS Delivery Location Country Code
14 SSR_DLOC_POSTCODE Character(4) VARCHAR2(4) NOT NULL HEIMS Campus Postcode
15 EFFDT_FROM Date(10) DATE Effective Date From
16 EFFDT_TO Date(10) DATE Effective Date To
17 IB_RESTMETHOD Character(10) VARCHAR2(10) NOT NULL REST Method
18 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
19 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
20 SSR_PROVIDER_TYPE Character(4) VARCHAR2(4) NOT NULL Provider Type
HEP=Higher Education Provider
NA=Not Applicable
TAC=Tertiary Admission Centre
VET=Vocational Education&Training
21 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
22 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
23 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
24 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time