PSPTSEC_TOKEN(SQL Table) |
Index Back |
|---|---|
Security Token Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTAPP_NAME |
Character(100) | VARCHAR2(100) NOT NULL | OAuth Name |
| 2 | PTAUTHSERVER |
Character(2) | VARCHAR2(2) NOT NULL |
OAuth2 Security Authorization Server type
AZ=AZURE IC=IDCS OK=OKTA PI=PING Default Value: IC |
| 3 | PTCLIENT_ID | Character(100) | VARCHAR2(100) NOT NULL | Client / Application ID |
| 4 | PTCLIENT_SECRET | Character(100) | VARCHAR2(100) NOT NULL | Client Secret |
| 5 | PTSECTYPE | Character(2) | VARCHAR2(2) NOT NULL |
OAuth2 Security Scope Type
B=Client and Resource C=Email Client Only CO=Client Only R=Resource Only Default Value: C |
| 6 | PTSCOPE | Character(2) | VARCHAR2(2) NOT NULL |
OAuth2 Security Scope Type
B=readwrite N=None R=read W=write Default Value: B |
| 7 | PTISS | Character(254) | VARCHAR2(254) NOT NULL | Redirect URI/URL |
| 8 | PTTOKENTYPEAT | Number(1,0) | SMALLINT NOT NULL |
Encrypted Flag
Default Value: 0 |
| 9 | PTTENANT | Character(254) | VARCHAR2(254) NOT NULL | Tenant |
| 10 | PTAUDIENCE1 | Character(254) | VARCHAR2(254) NOT NULL | Redirect URI/URL |
| 11 | PTAUDIENCE2 | Character(254) | VARCHAR2(254) NOT NULL | Redirect URI/URL |
| 12 | PTAUTHFLOW | Character(2) | VARCHAR2(2) NOT NULL |
OAuth2 Security Authorization Grant type
2L=Assertion 3L=Authorization Code CC=Client Credentials Default Value: 3L |
| 13 | PTIB_EXTNAME | Character(100) | VARCHAR2(100) NOT NULL | External User Name |
| 14 | PTSTATE | Character(36) | VARCHAR2(36) NOT NULL | Redirect URI/URL |
| 15 | PTREFRESH | Character(1) | VARCHAR2(1) NOT NULL |
Load Netting Rows
Default Value: 0 |
| 16 | PTTOKENURL | Character(254) | VARCHAR2(254) NOT NULL | Tenant |
| 17 | PTSCOPE_URL | Character(254) | VARCHAR2(254) NOT NULL | Redirect URI/URL |