SAE_BULK_TRANSAE_TARGET_IDSAE_SERVICE_CODECOFR=Course Offering
CSEC=Course Section
CTMP=Course Template
GRP=Group
MEMB=Membership
PRSN=Person
SASS=Section Association
SAE_SOURCED_IDA=Add
C=Change
D=Delete
SAE_TRAN_OP_ST(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_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 |
| 4 | SAE_SOURCED_ID |
Character(250) | VARCHAR2(250) NOT NULL | Sourced Id |
| 5 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Operation Mode
A=Add C=Change D=Delete |
| 6 | SAE_TRAN_FAIL_ST | Character(30) | VARCHAR2(30) NOT NULL | Fail Status |