TP_SYSTEMEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
1=User ID
2=Current User ID
3=EmplID
4=Current User ID & EmplID
5=User ID & EmplID
H=High Security
M=Secure
N=Non-Secure
Y/N Table Edit
Default Value: Y
SASS_TP_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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | TP_LANG | Character(30) | VARCHAR2(30) NOT NULL | External Site Language |
| 7 | DEFAULT_URL | Character(254) | VARCHAR2(254) NOT NULL | Default 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 |
| 16 | SECURE_VAL | Character(1) | VARCHAR2(1) NOT NULL |
Validation Security Level
H=High Security M=Secure N=Non-Secure Y/N Table Edit Default Value: Y |