FILENAMESETIDCA_SPSR_DELT_VW(SQL View) |
Index Back |
|---|---|
Sponsor File Delete Grid ViewView for the Grid in Sponsor File Delete Component |
| SELECT CASE WHEN IMP_LOG.FILENAME_OVERRIDE = ' ' THEN IMP_LOG.FILENAME ELSE IMP_LOG.FILENAME_OVERRIDE END AS FILENAME , IMP_LOG.OPRID , IMP_LOG.SETID , IMP_LOG.LASTUPDDTTM , IMP_LOG.PROCESS_INSTANCE , IMP_LOG.SPONSOR_ID , CUST.NAME1 , IMP_LOG.LOC_REFERENCE_ID FROM PS_CA_SPSR_IMP_LOG IMP_LOG , PS_CUSTOMER CUST WHERE IMP_LOG.SETID = CUST.SETID AND IMP_LOG.SPONSOR_ID = CUST.CUST_ID AND CUST.CUST_STATUS = 'A' AND DELETE_FLAG = 'N' AND ( SELECT COUNT(*) FROM PS_CA_SPNSR_FILE_U UPL WHERE IMP_LOG.FILENAME_UPLOADED = UPL.FILENAME AND IMP_LOG.PROCESS_INSTANCE = UPL.PROCESS_INSTANCE) > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FILENAME |
Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 2 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | UPLOAD_DTTM | DateTime(26) | TIMESTAMP | Upload Datetime |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | SPONSOR_ID | Character(15) | VARCHAR2(15) NOT NULL | SPONSOR_ID |
| 7 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 8 | LOC_REFERENCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Letter of Credit ID |