CS_BINDS_VW3(SQL View) |
Index Back |
|---|
| SELECT CS_BIND_VAR , DESCR , CS_BIND_TYPE , CS_FIELD_TYPE , CS_FIELD_LENGTH , CS_DATE_DISPLAY FROM PS_CS_BINDS WHERE CS_BIND_TYPE = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CS_BIND_VAR |
Character(30) | VARCHAR2(30) NOT NULL | Bind Variable |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | CS_BIND_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bind Variable Type
1=Transactional 3=Wizard |
| 4 | CS_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bind Variable Field Type
5/11/07 F-AHAYT-X0ES6 - Added new field type of Prompt
1=String 3=Date 4=Date/Time 5=Yes/No 6=Integer 7=Decimal 8=Prompt Table 9=Checkbox |
| 5 | CS_FIELD_LENGTH | Character(3) | VARCHAR2(3) NOT NULL |
Field Length
5/11/07 F-AHAYT-X0ES6 Added new Field Len of LNG
002=002 005=005 012=012 030=030 254=254 LNG=Long Char |
| 6 | CS_DATE_DISPLAY | Character(3) | VARCHAR2(3) NOT NULL |
Display Format
001=December 31, 2005 002=31 December 2005 003=12/31/2005 004=31/12/2005 005=Dec 31, 2005 006=31 Dec 2005 100=December 31, 2005 at 11:59 PM 102=31 December 2005 at 11:59 PM 104=12/31/2005 at 11:59 PM 106=31/12/2005 at 11:59 PM |