BUSINESS_UNITDefault Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
PROJECT_IDDefault Value: PROJECT_VW.PROJECT_ID
LASTUPDDTTMLASTUPDOPRIDFIELDNAMEGM_PRJ_DEPT_HIS(SQL Table) |
Index Back |
|---|---|
Grants Project Department HistThis is a history record that captures the changes done to the Institution, Department, Subdivision, Contact fields on the Project Department page. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJECT_VW.PROJECT_ID |
| 3 | 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. |
| 4 | 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. |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | OLDVALUE | Character(65) | VARCHAR2(65) NOT NULL | Old Value |
| 7 | NEWVALUE | Character(65) | VARCHAR2(65) NOT NULL | New Value |