| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SAE_TARGET_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
SAIP Target ID
|
| 2 |
SAE_TARGET_VERSION |
Character(4) |
VARCHAR2(4) NOT NULL |
Version
1.0=Version 1.0
1.5=Version 1.5
2.0=Version 2.0
2.0A=Version 2.0a
|
| 3 |
SAE_TARGET_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
SAIP Target Type
LDAP=LDAP
WBSV=Web Service
Default Value: WBSV
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
SAE_TARGET_REF |
Character(254) |
VARCHAR2(254) NOT NULL |
Agent Reference ID
|
| 6 |
SAE_DIR_PATH |
Character(100) |
VARCHAR2(100) NOT NULL |
Directory Path
|
| 7 |
SAE_GRD_IMP_ENBLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Grade Import
N=No
Y=Yes
|
| 8 |
SAE_EVNT_TRG_ENBLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Event Triggers
|
| 9 |
SAE_EVNT_LOG_LVL |
Character(4) |
VARCHAR2(4) NOT NULL |
Event Log Level
ALL=All
ERRO=Error
WARN=Warning
Default Value: ERRO
|
| 10 |
SAE_FTP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Upload File
Y/N Table Edit
|
| 11 |
SAE_EMB_CRED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Embed credentials
Default Value: N
|
| 12 |
SAE_FTP_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
FTP URL
|
| 13 |
SAE_FTP_USER_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
User Name
|
| 14 |
SAE_FTP_PASSWORD |
Character(254) |
VARCHAR2(254) NOT NULL |
Password
|
| 15 |
SAE_TARGET_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Node Name
Prompt Table:
PSMSGNODEDEFN
|
| 16 |
SAE_DIRECTORY_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Directory ID for LDAP
Prompt Table:
PSDSDIR
|
| 17 |
SAE_DELETE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Delete Type: either HARD or SOFT. If the delete type is HARD, then the entry is actually to be deleted. If it is SOFT, then a deleted status indicator is to be set.
HARD=Delete Record
SOFT=Inactivate Record
Default Value: SOFT
|
| 18 |
SAE_LDAP_PATH_GRP |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to Group
|
| 19 |
SAE_LDAP_PATH_MEM |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to membership
|
| 20 |
SAE_LDAP_PATH_OFFR |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to course offering
|
| 21 |
SAE_LDAP_PATH_PER |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to Person
|
| 22 |
SAE_LDAP_PATH_PERD |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding Path to Person Details
|
| 23 |
SAE_LDAP_PATH_SCAS |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to course section association
|
| 24 |
SAE_LDAP_PATH_SECT |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to course section
|
| 25 |
SAE_LDAP_PATH_TPLT |
Character(250) |
VARCHAR2(250) NOT NULL |
SAIP LDAP Binding path to course template
|
| 26 |
SAE_LSTSYNCPER_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization person date time. This is the date time stamp indicating when person entries were last synchronized.
|
| 27 |
SAE_LSTSYNCCOF_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization course offering date time. This is the date time stamp indicating when course offering entries were last synchronized.
|
| 28 |
SAE_LSTSYNCCSA_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization course section associations date time. This is the date time stamp indicating when course section association entries were last synchronized.
|
| 29 |
SAE_LSTSYNCCSC_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization course sections date time. This is the date time stamp indicating when course section entries were last synchronized.
|
| 30 |
SAE_LSTSYNCCTM_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization course template date time. This is the date time stamp indicating when course template entries were last synchronized.
|
| 31 |
SAE_LSTSYNCGRP_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization group date time. This is the date time stamp indicating when group entries were last synchronized.
|
| 32 |
SAE_LSTSYNCMEM_DTM |
DateTime(26) |
TIMESTAMP |
SAIP last synchronization membership date time. This is the date time stamp indicating when membership entries were last synchronized.
|
| 33 |
SAE_UPLOAD_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
File Upload Option
0=Upload To FTP
1=Upload To URL
Default Value: 0
|
| 34 |
URL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table:
PSURLDEFN
|
| 35 |
SAE_BATCHPROC_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enrollment Processing Mode
B=Send Enrollments in Bulk
E=Send Enrollments as Events
T=Events with Bulk Threshold
Default Value: E
|
| 36 |
SAE_BULK_THRESHOLD |
Number(6,0) |
INTEGER NOT NULL |
Bulk Threshold
|
| 37 |
SAE_CLSBAT_PRCMODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Term Rollover Processing Mode
B=Send Classes as Bulk
E=Send Classes as Events
T=Events with Bulk Threshold
Default Value: E
|
| 38 |
SAE_CLSBULK_TH |
Number(6,0) |
INTEGER NOT NULL |
Class Bulk Threshold
|