PTLT_PROJ_DEFN (SQL Table)	Index Back
Implementation Project Defn. Used in Setup Manager. Defines Implementation Project.

PTLT_PROJ_DEFN

(SQL Table)

Implementation Project Defn.

Used in Setup Manager. Defines Implementation Project.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTLT_PROJ_NAME Character(15) VARCHAR2(15) NOT NULL Used in Setup Manager v2.0 for Implementation Project Name.
Prompt Table: PTLT_PROJ_VW2

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 PTLT_PROJ_STATUS Character(1) VARCHAR2(1) NOT NULL The Project Status field is used in the Manage Implementation Projects page of the Setup Manager, and describes the current status of each Implementation Project that the user has created in Setup Manager
A=Assigned
C=Complete
G=Generated
I=In Progress
N=Not Started

4 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process

5 PTLT_GENERATEDDTTM DateTime(26) TIMESTAMP Last Generated Date/Time

6 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTLT_PROJ_NAME	Character(15)	VARCHAR2(15) NOT NULL	Used in Setup Manager v2.0 for Implementation Project Name. Prompt Table: PTLT_PROJ_VW2
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	PTLT_PROJ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The Project Status field is used in the Manage Implementation Projects page of the Setup Manager, and describes the current status of each Implementation Project that the user has created in Setup Manager A=Assigned C=Complete G=Generated I=In Progress N=Not Started
4	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process
5	PTLT_GENERATEDDTTM	DateTime(26)	TIMESTAMP	Last Generated Date/Time
6	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.