| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_VW
|
| 3 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: PROJECT.START_DT
|
| 4 |
SR_FREQUENCY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Report frequency type
B=Bi-weekly
M=Monthly
Q=Quarterly
S=Semi-monthly
U=User Defined
W=Weekly
Default Value: W
|
| 5 |
REQ_SR_FOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Require status reports for
A=Activity
P=Project
Default Value: P
|
| 6 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
Default Value: PROJECT.END_DT
|
| 7 |
WEEK_END_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Week End Date
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 8 |
SEND_REMINDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Send reminders flag
N=No
Y=Yes
|
| 9 |
DAYS_AHEAD |
Number(3,0) |
SMALLINT NOT NULL |
Number of days used as reminder for Status Report
1=One
2=Two
3=Three
|
| 10 |
USER_DEFINED_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined Dates
|
| 11 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
Default Value: PROJECT.DESCR
Prompt Table:
PROJECT_VW
Set Control Field: DESCR
|
| 12 |
ROW_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Row Number
|
| 13 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 14 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 15 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 16 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|