SAE_SETUP(SQL Table) |
Index Back |
|---|---|
Global Setup Record for SAIP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAE_EVNT_TRG_ENBLD | Character(1) | VARCHAR2(1) NOT NULL |
Enable Event Triggers
Y/N Table Edit |
| 2 | SAE_GRD_IMP_ENBLD | Character(1) | VARCHAR2(1) NOT NULL |
Enable Grade Import
N=No Y=Yes Y/N Table Edit |
| 3 | SAE_IMS_SOURCE | Character(50) | VARCHAR2(50) NOT NULL | IMS Source |
| 4 | SAE_FORMNAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
IMS Form Name
Prompt Table:
NAME_USAGE_TBL
|
| 5 | SAE_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
IMS Name
Prompt Table:
NAME_USAGE_TBL
|
| 6 | SAE_ADDRESS_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
IMS Address
Prompt Table:
ADDR_USAGE_TBL
|
| 7 | SAE_PHONE_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
IMS Phone
Prompt Table:
PHONE_USAGE_TBL
|
| 8 | SAE_WEB_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
IMS Web
Prompt Table:
ADDR_USAGE_TBL
|
| 9 | SAE_SMS_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
IMS SMS
Prompt Table:
PHONE_USAGE_TBL
|
| 10 | SAE_PREF_EMAILFLAG | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Email
N=Address Usage Y=Preferred Email |
| 11 | SAE_EMAIL_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Email Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 12 | SAE_DIR_PATH | Character(100) | VARCHAR2(100) NOT NULL | Directory Path |
| 13 | SAE_FTP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Upload File
Y/N Table Edit |
| 14 | SAE_EMB_CRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Embed credentials
Y/N Table Edit |
| 15 | SAE_FTP_URL | Character(254) | VARCHAR2(254) NOT NULL | FTP URL |
| 16 | SAE_FTP_USER_NAME | Character(30) | VARCHAR2(30) NOT NULL | User Name |
| 17 | SAE_FTP_PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |
| 18 | SAE_UNIT_ID | Number(4,0) | SMALLINT NOT NULL | Unit ID |