CS_BINDS_VW4(SQL View) |
Index Back |
|---|---|
Bind attr and cs_levelscm_cs_wordml:wordfile class - used in sql object to select level zero binds only |
| SELECT DISTINCT a.CS_BIND_VAR , a.cs_bind_type , a.cs_field_type , a.cs_field_length , a.cs_date_display , c.cs_displaytype FROM PS_CS_BINDS a , PS_CS_BIND_MAP_VW b , PS_CS_BIND_MAP_DTL c WHERE a.CS_BIND_VAR = b.CS_BIND_VAR AND b.CS_BIND_VAR = c.CS_BIND_VAR AND b.CS_SOURCE_TRANS = c.CS_SOURCE_TRANS AND b.CS_BIND_RECNAME= c.CS_BIND_RECNAME AND b.cs_level = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CS_BIND_VAR |
Character(30) | VARCHAR2(30) NOT NULL | Bind Variable |
| 2 | CS_BIND_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bind Variable Type
1=Transactional 3=Wizard |
| 3 | 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 |
| 4 | 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 |
| 5 | 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 |
| 6 | CS_DISPLAYTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
1=Xlat Long Name 2=Xlat Short Name 3=Xlat Value |