| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROPOSAL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Proposal ID
Prompt Table:
GM_PROP_ID_VW
|
| 3 |
VERSION_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID
Prompt Table:
GM_PROPOSAL
|
| 4 |
SUB_PROP_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
SUB_PROP_NBR
|
| 5 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 6 |
TITLE56 |
Character(56) |
VARCHAR2(56) NOT NULL |
TITLE56
|
| 7 |
PRIMARY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary
N=No
Y=Yes
Y/N Table Edit
|
| 8 |
INSTID |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution ID
Prompt Table:
GM_INSTITUTION
|
| 9 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
GM_DEPT_TBL_VW
|
| 10 |
MAJOR_SUBDIVISION |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Subdivision ID
Prompt Table:
GM_DEPT_TBL2_VW
|
| 11 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
GM_PROP_DEPTJVW
|
| 12 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
GM_REP_VW
|
| 13 |
ROW_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Row_Number
Default Value: 1
|
| 14 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 15 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 16 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
Default Value: GM_PROPOSAL.EMPLID
Prompt Table:
PROJ_MGR_VW
|
| 17 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
|
| 18 |
PPSL_TO_PRJCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Proposal Project To Project
D=Project Created
N=Project Not Created
P=Pre-Spending
Y=Yes
Default Value: N
|
| 19 |
SUB_PROP_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Proposal Status
A=Approved
C=Canceled
D=Denied
N=Assigned
P=Pending
R=Returned
S=Submitted
Default Value: P
|
| 20 |
LAST_REQ_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Requirement ID
|
| 21 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Prompt Table:
BUS_CAL_HOL_VW
|
| 22 |
STD_HOURS_DAY |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Standard Hours Day
|
| 23 |
STD_HOURS_WK |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours Week
|