BUSINESS_UNITDefault Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
PROJECT_IDSTART_DATESR_FREQUENCY_TYPEB=Bi-weekly
M=Monthly
Q=Quarterly
S=Semi-monthly
U=User Defined
W=Weekly
Default Value: W
REPORT_DUE_DATEPC_CPY_UNIQUEIDDefault Value: PROJECT.DESCR
PC_CPY_SRDT_TAO(SQL Table) |
Index Back |
|---|---|
Status Report DatesThis record stores all period dates for Status Reports |
| # | 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 |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | START_DATE |
Date(10) | DATE | 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 | REPORT_DUE_DATE |
Date(10) | DATE | Report Due Date |
| 6 | PC_CPY_UNIQUEID |
Character(15) | VARCHAR2(15) NOT NULL | Copy Unique ID |
| 7 | END_DATE | Date(10) | DATE | End Date |
| 8 | SR_START_DATE | Date(10) | DATE | Status Report start date |
| 9 | SR_END_DATE | Date(10) | DATE | Status Report end date |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: PROJECT.DESCR |