PC_CPY_SRFQ_TAO(SQL Table) |
Index Back |
|---|---|
Status Report frequency typeStatus Report Frequency type record |
| # | 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 |
| 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 | PC_CPY_UNIQUEID |
Character(15) | VARCHAR2(15) NOT NULL | Copy Unique ID |
| 6 | REQ_SR_FOR | Character(1) | VARCHAR2(1) NOT NULL |
Require status reports for
A=Activity P=Project Default Value: P |
| 7 | END_DATE | Date(10) | DATE NOT NULL | End Date |
| 8 | 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 |
| 9 | SEND_REMINDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Send reminders flag
N=No Y=Yes |
| 10 | DAYS_AHEAD | Number(3,0) | SMALLINT NOT NULL |
Number of days used as reminder for Status Report
1=One 2=Two 3=Three |
| 11 | USER_DEFINED_DAYS | Character(1) | VARCHAR2(1) NOT NULL | User Defined Dates |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: PROJECT.DESCR Prompt Table:
PROJECT_VW
|
| 13 | ROW_NUM | Number(3,0) | SMALLINT NOT NULL | Row Number |