SSR_BR_IDBV_NLD

(SQL View)
 Index Back

Identification Service Staging


SELECT SSR_BR_INDEX_ID , SSR_BR_MSGUUID , SSR_BR_TRANS_INOUT , SSR_BR_TRANS_DTTM , SSR_BR_TRANS_STAT , SERVICENAME , SSR_BR_MSGBO , SSR_BR_SENDER , SSR_BR_RECEIVER , SSR_BR_ACCEPTED ,IBPUBTRANSACTID , EMPLID , BIRTHDATE , SSR_BR_NAT_ID_NLD , SSR_BR_SEX_NLD , SAD_SL_SOFI_NBR , LAST_NAME , NAME_ROYAL_PREFIX , SSR_BR_FST_NMS_NLD , SSR_BR_STREET_NLD , NUM1 , NUM2 , SSR_BR_LOC_DESCR , SSR_BR_HOUSE_I_NBR , SSR_BR_POSTAL_NLD , CITY , SSR_BR_FR_ADDR_1 , SSR_BR_FR_ADDR_2 , SSR_BR_FR_ADDR_3 ,SSR_BR_COUNTRY_NLD , SAD_GBA_B_YR_NLD ,SAD_GBA_B_MN_NLD , SSR_BR_SUBSCR_NLD ,SCC_BRINCD_NLD FROM PS_SSR_BR_IDBO_NLD WHERE SSR_BR_TRANS_INOUT = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_BR_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Transaction Index ID
2 SSR_BR_MSGUUID Character(50) VARCHAR2(50) NOT NULL Message ID
3 SSR_BR_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
I=Inbound
O=Outbound
4 SSR_BR_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
5 SSR_BR_TRANS_STAT Character(1) VARCHAR2(1) NOT NULL Studielink Message Status
A=Partly processed
C=Created
P=Processed
R=Received
S=Suspended
T=Error
U=Unprocessed
V=Sent
6 SERVICENAME Character(50) VARCHAR2(50) NOT NULL Service name
7 SSR_BR_MSGBO Character(50) VARCHAR2(50) NOT NULL Message
8 SSR_BR_SENDER Character(4) VARCHAR2(4) NOT NULL Transaction Sender
9 SSR_BR_RECEIVER Character(4) VARCHAR2(4) NOT NULL Receiver
10 SSR_BR_ACCEPTED Character(1) VARCHAR2(1) NOT NULL Accepted Indicator
J=Accepted
N=Rejected
11 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
13 BIRTHDATE Date(10) DATE Date of Birth
14 SSR_BR_NAT_ID_NLD Character(20) VARCHAR2(20) NOT NULL Educational Number
15 SSR_BR_SEX_NLD Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
16 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
17 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
18 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
19 SSR_BR_FST_NMS_NLD Character(200) VARCHAR2(200) NOT NULL Firstnames
20 SSR_BR_STREET_NLD Character(24) VARCHAR2(24) NOT NULL Street
21 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
22 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
23 SSR_BR_LOC_DESCR Character(35) VARCHAR2(35) NOT NULL Location Description
24 SSR_BR_HOUSE_I_NBR Character(2) VARCHAR2(2) NOT NULL House Number Indication
25 SSR_BR_POSTAL_NLD Character(7) VARCHAR2(7) NOT NULL Postal Code
26 CITY Character(30) VARCHAR2(30) NOT NULL City
27 SSR_BR_FR_ADDR_1 Character(35) VARCHAR2(35) NOT NULL Foreign Address Line 1
28 SSR_BR_FR_ADDR_2 Character(35) VARCHAR2(35) NOT NULL Foreign Address Line 2
29 SSR_BR_FR_ADDR_3 Character(35) VARCHAR2(35) NOT NULL Foreign Address Line 3
30 SSR_BR_COUNTRY_NLD Character(4) VARCHAR2(4) NOT NULL Country
31 SAD_GBA_B_YR_NLD Character(4) VARCHAR2(4) NOT NULL GBA Year of Birth
32 SAD_GBA_B_MN_NLD Character(2) VARCHAR2(2) NOT NULL GBA Month of Birth
33 SSR_BR_SUBSCR_NLD Character(4) VARCHAR2(4) NOT NULL Indication Subscription
AAN=Set/Change Subscription Date
UIT=Cancel subscription
34 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode