PSADS_REQUEST

index back

ADS Approval Request


PeopleSoft Field Name Field Type Column Type Description
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

Prompt Table: PSPROJECTDEFN

PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTSUBMITDTTM DateTime(26) TIMESTAMP DateTime Submitted

Default: %datetime

PTSUBMITOPRID Character(30) VARCHAR2(30) NOT NULL Submittal Operator
DESCR Character(30) VARCHAR2(30) NOT NULL Description
PTADS_SCHED_DATE Date(10) DATE Schedule Date
PTADS_SCHED_TIME Time(15) TIMESTAMP Schedule Time
PTADS_SCHED_NOW Character(1) VARCHAR2(1) NOT NULL Schedule Immediately
N=False
Y=True
PT_COMMIT_INTERVAL Number(8,0) INTEGER NOT NULL Commit Interval
PTLANGUAGELIST Character(254) VARCHAR2(254) NOT NULL Selected Languages
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.
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19