SAE_TRAN_OP_VW

(SQL View)
 Index Back

SELECT BULK_TRAN_OP.SAE_BULK_TRAN , BULK_TRAN_OP.SAE_TARGET_ID , BULK_TRAN_OP.SAE_SERVICE_CODE ,BULK_FILE.SAE_FTP_URL , BULK_TRAN_OP.SAE_SOURCED_ID , BULK_TRAN_OP.SAE_MODE , BULK_TRAN_OP.SAE_TRAN_FAIL_ST FROM %Table(SAE_TRAN_OP_ST) BULK_TRAN_OP , %Table(SAE_BULK_FILE) BULK_FILE WHERE BULK_TRAN_OP.SAE_BULK_TRAN=BULK_FILE.SAE_BULK_TRAN AND BULK_TRAN_OP.SAE_TARGET_ID=BULK_FILE.SAE_TARGET_ID AND BULK_TRAN_OP.SAE_SERVICE_CODE=BULK_FILE.SAE_SERVICE_CODE UNION SELECT BULK_TRAN_OP.SAE_BULK_TRAN , BULK_TRAN_OP.SAE_TARGET_ID , 'COFR' ,BULK_FILE.SAE_FTP_URL , BULK_TRAN_OP.SAE_SOURCED_ID , BULK_TRAN_OP.SAE_MODE , BULK_TRAN_OP.SAE_TRAN_FAIL_ST FROM %Table(SAE_TRAN_OP_ST) BULK_TRAN_OP , %Table(SAE_BULK_FILE) BULK_FILE WHERE BULK_FILE.SAE_SERVICE_CODE = 'COFR' AND BULK_TRAN_OP.SAE_SERVICE_CODE = 'CTMP' AND BULK_TRAN_OP.SAE_BULK_TRAN=BULK_FILE.SAE_BULK_TRAN AND BULK_TRAN_OP.SAE_TARGET_ID=BULK_FILE.SAE_TARGET_ID UNION SELECT BULK_TRAN_OP.SAE_BULK_TRAN , BULK_TRAN_OP.SAE_TARGET_ID , 'CSEC' ,BULK_FILE.SAE_FTP_URL , BULK_TRAN_OP.SAE_SOURCED_ID , BULK_TRAN_OP.SAE_MODE , BULK_TRAN_OP.SAE_TRAN_FAIL_ST FROM %Table(SAE_TRAN_OP_ST) BULK_TRAN_OP , %Table(SAE_BULK_FILE) BULK_FILE WHERE BULK_FILE.SAE_SERVICE_CODE = 'CSEC' AND BULK_TRAN_OP.SAE_SERVICE_CODE = 'CTMP' AND BULK_TRAN_OP.SAE_BULK_TRAN=BULK_FILE.SAE_BULK_TRAN AND BULK_TRAN_OP.SAE_TARGET_ID=BULK_FILE.SAE_TARGET_ID UNION SELECT BULK_TRAN_OP.SAE_BULK_TRAN , BULK_TRAN_OP.SAE_TARGET_ID , 'SASS' ,BULK_FILE.SAE_FTP_URL , BULK_TRAN_OP.SAE_SOURCED_ID , BULK_TRAN_OP.SAE_MODE , BULK_TRAN_OP.SAE_TRAN_FAIL_ST FROM %Table(SAE_TRAN_OP_ST) BULK_TRAN_OP , %Table(SAE_BULK_FILE) BULK_FILE WHERE BULK_FILE.SAE_SERVICE_CODE = 'SASS' AND BULK_TRAN_OP.SAE_SERVICE_CODE = 'CTMP' AND BULK_TRAN_OP.SAE_BULK_TRAN=BULK_FILE.SAE_BULK_TRAN AND BULK_TRAN_OP.SAE_TARGET_ID=BULK_FILE.SAE_TARGET_ID

# 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_FTP_URL Character(254) VARCHAR2(254) NOT NULL FTP URL
5 SAE_SOURCED_ID Character(250) VARCHAR2(250) NOT NULL Sourced Id
6 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete
7 SAE_TRAN_FAIL_ST Character(30) VARCHAR2(30) NOT NULL Fail Status