TP_SYSTEMA=Active
I=Inactive
Default Value: A
1=User ID
2=Current User ID
3=EmplID
4=Current User ID & EmplID
5=User ID & EmplID
Default Value: 1
H=High Security
M=Secure
N=Non-Secure
Default Value: M
Default Value: 30
ESA_PFL_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TP_SYSTEM |
Character(30) | VARCHAR2(30) NOT NULL | LMS Authentication Profile |
| 2 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | TP_LANG | Character(30) | VARCHAR2(30) NOT NULL | External Site Language |
| 6 | DEFAULT_URL | Character(254) | VARCHAR2(254) NOT NULL | Default URL |
| 7 | CONFIG_URL | Character(254) | VARCHAR2(254) NOT NULL | Configuration URL |
| 8 | LOGIN_URL | Character(254) | VARCHAR2(254) NOT NULL | Login URL |
| 9 | LOGOUT_URL | Character(254) | VARCHAR2(254) NOT NULL | Logout URL |
| 10 | DISABLE_MSG | Character(254) | VARCHAR2(254) NOT NULL | Disable Message |
| 11 | ESA_COMMENT | Character(254) | VARCHAR2(254) NOT NULL | Comment |
| 12 | PS_COMPID | Character(15) | VARCHAR2(15) NOT NULL | PeopleSoft Company ID |
| 13 | TP_COMPID | Character(15) | VARCHAR2(15) NOT NULL | Third-Party Company ID |
| 14 | UN_PREFIX | Character(10) | VARCHAR2(10) NOT NULL | User Name Prefix |
| 15 | AUTH_VALUE | Character(1) | VARCHAR2(1) NOT NULL |
Authentication Values
1=User ID 2=Current User ID 3=EmplID 4=Current User ID & EmplID 5=User ID & EmplID Default Value: 1 |
| 16 | SECURE_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Validation Security Level
H=High Security M=Secure N=Non-Secure Default Value: M |
| 17 | TIMEOUT | Number(3,0) | SMALLINT NOT NULL |
Timeout
Default Value: 30 |
| 18 | UPDATED_DATETIME | DateTime(26) | TIMESTAMP | Last Updated |
| 19 | UPDATED_USERID | Character(30) | VARCHAR2(30) NOT NULL | Updated UserID |
| 20 | LMS_MACHINE | Character(30) | VARCHAR2(30) NOT NULL | LMS Server |
| 21 | LMS_PORT_NBR | Character(6) | VARCHAR2(6) NOT NULL | Ext Syst Machine Port Number |
| 22 | PRIVATEKEY | Character(254) | VARCHAR2(254) NOT NULL | Private Key |
| 23 | SECRETKEY | Long Character(2000) | VARCHAR2(2000) | Secret Key |