PTWSSINBSAML (SQL Table)	Index Back
WSS Inbound SAML Table Web Services Security for InBound Security Assertion MarkUp Language (SAML]

PTWSSINBSAML

(SQL Table)

WSS Inbound SAML Table

Web Services Security for InBound Security Assertion MarkUp Language (SAML]

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CERTALIAS Character(50) VARCHAR2(50) NOT NULL Certificate Alias
Prompt Table: PSCERTALIAS_VW
Set Control Field: CERTALIAS

2 PTISSUER Character(30) VARCHAR2(30) NOT NULL Issuer for Security Assertion MarkUp Language (SAML]

3 PTSUBJECTNAME Character(114) VARCHAR2(114) NOT NULL The SubjectName for Security Assertion MarkUp Language (SAML]

4 PTQUALIFIERNAME Character(30) VARCHAR2(30) NOT NULL Domain Name of the SubjectName for Security Assertion MarkUp Language (SAML]

5 PTMAPPSFTUSERID Character(30) VARCHAR2(30) NOT NULL Mapping from SAML SubjectName to PeopleSoft User.
Prompt Table: PTWSSOPRSAML_VW

6 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
Default Value: A

7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

8 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.

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CERTALIAS	Character(50)	VARCHAR2(50) NOT NULL	Certificate Alias Prompt Table: PSCERTALIAS_VW Set Control Field: CERTALIAS
2	PTISSUER	Character(30)	VARCHAR2(30) NOT NULL	Issuer for Security Assertion MarkUp Language (SAML]
3	PTSUBJECTNAME	Character(114)	VARCHAR2(114) NOT NULL	The SubjectName for Security Assertion MarkUp Language (SAML]
4	PTQUALIFIERNAME	Character(30)	VARCHAR2(30) NOT NULL	Domain Name of the SubjectName for Security Assertion MarkUp Language (SAML]
5	PTMAPPSFTUSERID	Character(30)	VARCHAR2(30) NOT NULL	Mapping from SAML SubjectName to PeopleSoft User. Prompt Table: PTWSSOPRSAML_VW
6	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
7	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
8	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.
9	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.