| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 4 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 5 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 6 |
EMPLID_OLD |
Character(11) |
VARCHAR2(11) NOT NULL |
Previous Employee ID
|
| 7 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 8 |
SQL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
|
| 9 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Exist
|
| 10 |
CHECKLIST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Checklist Type
HIR=Hiring
MED=Medical
ORG=Organizational Instance
OTH=Other
TER=Termination
TRN=Training
XFR=Transfer
|
| 11 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
|
| 12 |
ADDR_TYPE1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Determines the type of Address. Defined to conform with Email and Phone types.
BILL=Billing
BUSN=Business
CAMP=Campus
CELL=Cellular
DORM=Dormitory
FAX=FAX
HOME=Home
MAIL=Mailing
OTR=Other
PERM=Permanent
PGR1=Pager 1
PGR2=Pager 2
PREF=Preferred
TELX=Telex
WORK=Work
|
| 13 |
NAME_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Part of Name
F=First
L=Last
M=Middle
T=Title
U=Full
|
| 14 |
FIRST_NAME_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Name Part
|
| 15 |
MIDDLE_NAME_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Middle Name Name Part
|
| 16 |
LAST_NAME_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Name Part
|
| 17 |
TITLE_NAME_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Maps a field on NAMES to be used as the Title part.
|
| 18 |
NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of Name
|
| 19 |
NAME_PARSE_OPTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Parsing
ADD=Parse @ Initial Add Entry Only
EVER=Parse at Every Name Change
NO=No Name Parsing
|
| 20 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 21 |
DEFAULT_SECT_SIZE |
Number(3,0) |
SMALLINT NOT NULL |
Default Section Size
|
| 22 |
TRANSCIPT_DT_PRT |
Character(2) |
VARCHAR2(2) NOT NULL |
Transcript Date Print
C=Print Class Dates
N=Do Not Print Any Dates
S=Print Session Dates
T=Print Term Dates
|