| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE2
|
| 4 |
DTTM_STAMP |
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.
|
| 5 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 6 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 7 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
AID_YEAR_CAREER
|
| 8 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 9 |
SALUT_NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Salutation Name
Prompt Table:
NAME_USAGE_TBL
|
| 10 |
ADDR_NAME_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Name
Prompt Table:
NAME_USAGE_TBL
|
| 11 |
ADMIN_FUNCTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Administrative Function
Default Value: FINA
Prompt Table:
ADM_FUNCTN_TBL
|
| 12 |
COMM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
Communication Category
Prompt Table:
COMM_CATG_VW
|
| 13 |
SCC_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code
Prompt Table:
%EDITTABLE3
|
| 14 |
INST_METHODOLOGY |
Character(1) |
VARCHAR2(1) NOT NULL |
Institutional Methodology
Y/N Table Edit
Default Value: N
|
| 15 |
XTRCT_FILE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Extract File Format
C=Comma Separated Values
J=JetForm
L=Line Printer
O=Other
W=MS-Word
Default Value: J
|
| 16 |
COMM_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Person responsible for the communication
Prompt Table:
PEOPLE_SRCH
|
| 17 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 18 |
FROM_DT |
Date(10) |
DATE |
From Date
Default Value: %date
|
| 19 |
TO_DT |
Date(10) |
DATE |
To Date
Default Value: %date
|
| 20 |
FAN_UPDATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update FAN Attributes
Y/N Table Edit
Default Value: Y
|
| 21 |
USE_CURRENT_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Current Effective Address
Y/N Table Edit
Default Value: N
|
| 22 |
COMM_DTTM |
DateTime(26) |
TIMESTAMP |
Communication DateTime
|
| 23 |
AWARD_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Period
A=Academic
N=Non Standard
Default Value: A
|
| 24 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 25 |
EXT_OVERRIDE_FLAG |
Character(50) |
VARCHAR2(50) NOT NULL |
External Override Flags
|
| 26 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Prompt Table:
%EDITTABLE
|
| 27 |
FAN_SELECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Canceled/Declined Awards
Y/N Table Edit
Default Value: N
|
| 28 |
SEQ_3C |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Prompt Table:
STDNT_COM_DT_VW
|
| 29 |
TEMPLATE_PATH |
Character(80) |
VARCHAR2(80) NOT NULL |
Template Path
|
| 30 |
PRINT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Send to Printer
Y/N Table Edit
Default Value: N
|