PSPTDEFSECINRL(SQL Table) |
Index Back |
|---|---|
Definition Group Inclusion RulDefinition Group Inclusion Rules |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OBJGROUPID |
Character(18) | VARCHAR2(18) NOT NULL | Object Group ID |
| 2 | OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Object Name
Default Value: PSPTDEFSEC_WRK.OBJNAME |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | SEQNO2 |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Default Value: APP_DES_OBJECTS.RECNAME |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSPTDBFLDLABL_V |
| 7 | PTBINDTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Operation
!==!= <=< <==<= === >=> >==>= 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 |
| 8 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |