PROJ_PRL_SCHED

(SQL Table)
Index Back

Projects R8.8 prototype

Projects R8.8 prototype

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 RESOURCE_REQ_ID Character(15) VARCHAR2(15) NOT NULL Resource Requirement ID
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 PRL_SCHED_TYPE Character(1) VARCHAR2(1) NOT NULL Schedule Type
C=Cancelled
E=Extension
P=Pending Extension
Q=Pending Change
R=Regular
X=Early Removal
9 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
10 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
11 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.
12 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.