GPDE_BS_BLOCK_IDGPDE_BS_NAME_IDY/N Table Edit
Default Value: N
K=Required if known
K2=Not Mandatory
M=Mandatory
M2=Mandatory under Condition
Y/N Table Edit
Default Value: N
GPDE_BS_DETL(SQL Table) |
Index Back |
|---|---|
Data Block StructureData Block Structure |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPDE_BS_BLOCK_ID |
Character(4) | VARCHAR2(4) NOT NULL | Block Baustein |
| 2 | GPDE_BS_NAME_ID |
Character(30) | VARCHAR2(30) NOT NULL | Data Block Name |
| 3 | GPDE_BS_VAR_LEN_SW | Character(1) | VARCHAR2(1) NOT NULL |
Block short description
Y/N Table Edit Default Value: N |
| 4 | GPDE_BS_FROM | Number(3,0) | SMALLINT NOT NULL | Block Data Start Position |
| 5 | GPDE_BS_TO | Number(3,0) | SMALLINT NOT NULL | Block Data End Position |
| 6 | GPDE_BS_DEC | Number(6,0) | INTEGER NOT NULL | Block Data number of decimal |
| 7 | GPDE_BS_LENGTH | Number(6,0) | INTEGER NOT NULL | Data Length |
| 8 | GPDE_BS_TYP | Character(10) | VARCHAR2(10) NOT NULL | Data Type |
| 9 | GPDE_BS_ART | Character(2) | VARCHAR2(2) NOT NULL |
Data Block type of requirement
K=Required if known K2=Not Mandatory M=Mandatory M2=Mandatory under Condition |
| 10 | GPDE_BS_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Block description |
| 11 | 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 |