SCC_TM_PTAILIST

(SQL View)
Index Back

ptai list view


SELECT ptai_list_id , portal_name , ptai_label , ptai_descrlong , ptai_active_flg , ptai_is_tmpl , ptai_parent_tmpl , ptai_list_status , last_update_dttm , lastupdoprid , createoprid , created_dttm FROM %Table(PTAI_LIST)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TM_LIST_ID Character(31) VARCHAR2(31) NOT NULL Template ID
2 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
3 SCC_TM_LABEL Character(100) VARCHAR2(100) NOT NULL Title
4 SCC_TM_DESCRLONG Long Character CLOB Description
5 SCC_TM_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active
N=No
Y=Yes
6 SCC_TM_IS_TMPL Character(1) VARCHAR2(1) NOT NULL Template

Y/N Table Edit

7 SCC_TM_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Parent Template ID
8 SCC_TM_LIST_STATUS Character(2) VARCHAR2(2) NOT NULL Status
CA=Cancelled
CP=Completed
IP=In Progress
9 LAST_UPDATE_DTTM 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.
10 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.
11 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
12 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime