GPDE_BS_DEFN(SQL Table) |
Index Back |
|---|---|
Data Block DefinitionData Block Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | Block Baustein | |
| 2 | GPDE_BS_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Block description |
| 3 | GPDE_BS_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Block short description |
| 4 | GPDE_BS_LENGTH | Number(6,0) | INTEGER NOT NULL | Data Length |
| 5 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |