# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
2 |
PTSF_NAV_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cref From Portal
|
3 |
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.
|
4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
5 |
PORTAL_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Label
|
6 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
|
7 |
PT_PORTAL_MRU_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Most recently used id
|
8 |
PORTAL_OBJNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Object Name
|
9 |
PORTAL_URLTEXT |
Long Character |
CLOB |
Portal URL Logical Text
|
10 |
USECOUNT |
Number(3,0) |
SMALLINT NOT NULL |
Use Count
|