HCSC_DYNAMIC_VW(SQL View) |
Index Back |
|---|---|
Recipient search resultRecipient search result are displayed on this dynamic view. |
| SELECT 'A' ,'B' ,'C' ,'D' ,'E' ,'F' ,'G' ,'H' ,'I' ,'J' FROM PS_INSTALLATION WHERE 1=2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_KEY1_NOPROMPT | Character(65) | VARCHAR2(65) NOT NULL | Key 1 with no prompt |
| 2 | HCSC_DESCR100_1 | Character(100) | VARCHAR2(100) NOT NULL | Description Field of mixed character length 100 |
| 3 | HCSC_KEY2_NOPROMPT | Character(65) | VARCHAR2(65) NOT NULL | Key 2 with no prompt |
| 4 | HCSC_DESCR100_2 | Character(100) | VARCHAR2(100) NOT NULL | Description Field of mixed character length 100 |
| 5 | HCSC_KEY3_NOPROMPT | Character(65) | VARCHAR2(65) NOT NULL | Key 3 with no prompt |
| 6 | HCSC_DESCR100_3 | Character(100) | VARCHAR2(100) NOT NULL | Description Field of mixed character length 100 |
| 7 | HCSC_KEY4_NOPROMPT | Character(65) | VARCHAR2(65) NOT NULL | Key 4 with no prompt |
| 8 | HCSC_DESCR100_4 | Character(100) | VARCHAR2(100) NOT NULL | Description Field of mixed character length 100 |
| 9 | HCSC_DUMMY_FIELD | Character(254) | VARCHAR2(254) NOT NULL | Dummy field to hold value |
| 10 | HCSC_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Description Field of mixed character length 100 |