| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table:
INSTITUTN_SCRTY
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
AV_PEOPLE_SRCH
|
| 3 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 4 |
CNST_ACTN_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Action Nbr
Default Value: NEW
|
| 5 |
RSP_ASGN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Responsible person assignment type
S=Staff
U=Unit
V=Volunteer
Default Value: S
|
| 6 |
RSPL_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible Person
Prompt Table:
%EDITTABLE2
|
| 7 |
SOL_ASGN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Assignment Type
S=Staff
U=Unit
V=Volunteer
|
| 8 |
SLCTR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Solicitor
Prompt Table:
%EDITTABLE
|
| 9 |
PRSP_MGR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Prospect Mgr ID
|
| 10 |
PRSP_MGR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
PM Type
|
| 11 |
UNIT_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Unit Code
Prompt Table:
AV_SOL_UNT_VW
|
| 12 |
STRATEGY_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Strategy Number
Prompt Table:
AV_STRATEGY_VW2
|
| 13 |
ACTN_RSLT_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Result Code
Prompt Table:
AV_C_AC_RSLT_VW
|
| 14 |
ACTN_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Action Description
|
| 15 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 16 |
ACTN_TYPE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Action Type Code
Prompt Table:
AV_C_ACTN_TP_VW
|
| 17 |
ACTN_STAT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Action Status
Default Value: SCH
Prompt Table:
AV_C_AC_STAT_VW
|
| 18 |
PLANNED_DT |
Date(10) |
DATE |
Planned Date
Default Value: %date
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: AV_INSTALL_INST.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 20 |
ASK_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Ask From
|
| 21 |
ASK_TO_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Ask To
|
| 22 |
OTH_ASGN_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Others Assigned
|
| 23 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 24 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 25 |
CMPL_DT |
Date(10) |
DATE |
Complete Date
|
| 26 |
EXPIRATION_DT |
Date(10) |
DATE |
Expiration Date
|
| 27 |
CMTMT_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Commitment Amount
|
| 28 |
RPT_DT |
Date(10) |
DATE |
Report Date
|
| 29 |
AUTHOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Author ID
Prompt Table:
AV_STAFF_STF_VW
|
| 30 |
CNTC_TYPE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Contact Type Code
Prompt Table:
AV_C_AC_CNT_VW
|
| 31 |
CNTC_RPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Report Flag
|
| 32 |
CNTC_SMRY_DESCR |
Long Character |
CLOB |
Contact Report
|
| 33 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 34 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 35 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 36 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|