PROJECTNAMEPTADSNAMEPTADSCONTENTIDSEQNBRPrompt Table: PTADSRECFLD_VW
!==!=
<=<
<==<=
===
>=>
>==>=
AL=All
BG=Begins with
BT=Between
IL=Is NULL
IN=In
LK=Like
NBT=Not Between
NIN=Not In
NL=Is Not NULL
NLK=Not Like
Default Value: AL
PSPROJBINDITEM(SQL Table) |
Index Back |
|---|---|
ADS Project Bind Items |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 3 | PTADSCONTENTID |
Number(6,0) | INTEGER NOT NULL | ADS Content Identifier |
| 4 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | PTBINDSYMBOL | Character(18) | VARCHAR2(18) NOT NULL |
ADS Bind Symbols
Prompt Table: PTADSRECFLD_VW |
| 6 | PTBINDTYPE | Character(3) | VARCHAR2(3) NOT NULL |
ADS Bind Type
!==!= <=< <==<= === >=> >==>= AL=All BG=Begins with BT=Between IL=Is NULL IN=In LK=Like NBT=Not Between NIN=Not In NL=Is Not NULL NLK=Not Like Default Value: AL |
| 7 | PTADSBINDEXPR | Long Character(14000) | CLOB | ADS Bind Expression |