SAE_BULK_TRANSAE_TARGET_IDSAE_INTERFACE_NAMESAE_SERVICE_CODECOFR=Course Offering
CSEC=Course Section
CTMP=Course Template
GRP=Group
MEMB=Membership
PRSN=Person
SASS=Section Association
SAE_BULK_ISUMRY(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAE_BULK_TRAN |
Character(250) | VARCHAR2(250) NOT NULL | Transaction ID |
| 2 | SAE_TARGET_ID |
Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
| 3 | SAE_INTERFACE_NAME |
Character(20) | VARCHAR2(20) NOT NULL | interface Name |
| 4 | SAE_SERVICE_CODE |
Character(4) | VARCHAR2(4) NOT NULL |
Service Name
COFR=Course Offering CSEC=Course Section CTMP=Course Template GRP=Group MEMB=Membership PRSN=Person SASS=Section Association |
| 5 | SAE_FULL_SUCCESS | Signed Number(7,0) | DECIMAL(6) NOT NULL | Full Success Count |
| 6 | SAE_PARTIAL_SUCCES | Signed Number(7,0) | DECIMAL(6) NOT NULL | Partial Success Count |
| 7 | SAE_FAILURE | Signed Number(7,0) | DECIMAL(6) NOT NULL | Failures Count |