| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 4 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 5 |
CIM_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicate the type of Data Importer mode/operation to execute (Import or Purge)
I=Import
P=Purge
Default Value: I
|
| 6 |
CIM_LOG_LEVEL |
Number(1,0) |
SMALLINT NOT NULL |
Logging Level Indicator
Default Value: 0
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|
| 8 |
RA_LIST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Audience ID
Prompt Table:
RA_LIST_IMP_VW
|
| 9 |
BYPASS_VAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass validation operation when processing rows or sets of rows
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
BYPASS_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass all update/modification processing indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 11 |
BYPASS_ADD |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to indicate that no new records should be processed
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 12 |
BYPASS_SM |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass executing search / match operations in order to identify individuals
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 13 |
CIM_NOSM_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to specify the action to be performed when the Search/Match infrastructure is disabled. Update and Error are not valid here.
A=Add Person
I=Ignore
R=Ready for Processing
S=Suspend
|
| 14 |
PERSON_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID to be used to create a person (consumer)
Default Value: INSTALLATION_BO.SETID
|
| 15 |
CREATED_BY_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 16 |
BATCH_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
CDH INTERFACE TABLE FIELD - BATCH_ID
|
| 17 |
TEST_REC_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Unique record number within a batch. This field was created by CRM and should be replaced with the OFFICIAL version of the field from Campus.
|
| 18 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID codes.
|
| 19 |
DATE_LOADED |
Date(10) |
DATE NOT NULL |
Date campus information loaded
|
| 20 |
IMP_SOURCE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field designates the source of the data import for import of prospects and test scores into CRM. Valid values can designate either Campus or External sources.
CAMP=Campus Solutions
EXT=External
|
| 21 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution field to store institution information in campus solution system.
|
| 22 |
ADM_RECR_CTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Recruiting Center
|
| 23 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic career field coming from campus solution system.
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
|
| 24 |
MSGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
|
| 25 |
CNT_ROWS |
Number(9,0) |
DECIMAL(9) NOT NULL |
Total Row Count
Default Value: 0
|
| 26 |
CNT_PROCESSED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Count of the number of rows processed
Default Value: 0
|
| 27 |
CNT_PURGED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Count of rows purged
Default Value: 0
|
| 28 |
CNT_POSTED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Count of rows posted (add or update)
Default Value: 0
|
| 29 |
CNT_SKIPPED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of rows not processed for some reason
|
| 30 |
CNT_ADDED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Count of the number of new rows/people created
Default Value: 0
|
| 31 |
CNT_UPDATED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of rows/constituents updated (modified or changed)
Default Value: 0
|
| 32 |
CNT_ERRORS |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of rows failing validation or generating errors
Default Value: 0
|
| 33 |
CNT_IGNORED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of rows marked as ignored
Default Value: 0
|
| 34 |
CNT_SUSPENDED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of rows marked as Suspended
Default Value: 0
|
| 35 |
CNT_UNCHANGED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of rows unchanged. These rows had no effect on the underlying data
Default Value: 0
|
| 36 |
LAST_ROW_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Last row status processed during an import operation
A=Add Person
E=Error
I=Ignore
R=Ready/Active
S=Suspend
U=Update Person
|
| 37 |
LAST_ROW_COMMIT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Last row number committed to the database
|
| 38 |
COMMIT_DTTM |
DateTime(26) |
TIMESTAMP |
Commit Date Time
|
| 39 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 40 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 41 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 42 |
MESSAGE_TEXT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Text
|
| 43 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 44 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 45 |
ROW_CNT |
Number(18,0) |
DECIMAL(18) NOT NULL |
Audience Row Count
|
| 46 |
CM_PURPOSE_TYPE_ID |
Number(6,0) |
INTEGER NOT NULL |
Relationship Contact Method Purpose ID
|