GVT_CPDF_FLD_NBRC=Character
D=Date
N=Number
N=No
Y=Yes
L=Left
N=No Padding
R=Right
GVT_CPDF_FLDTBL(SQL Table) |
Index Back |
|---|---|
CPDF Field Table6/2000: Added fields to support Dynamic and Status SQR processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_CPDF_FLD_NBR |
Number(3,0) | SMALLINT NOT NULL | Field Number |
| 2 | GVT_CPDF_FLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field Type
C=Character D=Date N=Number |
| 3 | GVT_CPDF_FLD_LGTH | Number(3,0) | SMALLINT NOT NULL | Field Length |
| 4 | GVT_CPDF_FLD_NAME | Character(20) | VARCHAR2(20) NOT NULL | Field Name |
| 5 | GVT_CPDF_DEF_VALUE | Character(1) | VARCHAR2(1) NOT NULL | Default Field Value |
| 6 | GVT_CPDF_TBL_DEFLT | Character(1) | VARCHAR2(1) NOT NULL | CPDF Table Default Value |
| 7 | GVT_CPDF_TRUNC_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Truncate CPDF Field
N=No Y=Yes |
| 8 | GVT_CPDF_FLD_PAD | Character(1) | VARCHAR2(1) NOT NULL |
Side of field to pad
L=Left N=No Padding R=Right |
| 9 | GVT_CPDF_PAD_CHAR | Character(1) | VARCHAR2(1) NOT NULL | Pad Character |
| 10 | GVT_CPDF_ST_STRPOS | Number(3,0) | SMALLINT NOT NULL | Status Start Position |
| 11 | GVT_CPDF_DY_STRPOS | Number(3,0) | SMALLINT NOT NULL | Dynamic Start Position |
| 12 | GVT_CPDF_EDIT_MASK | Character(20) | VARCHAR2(20) NOT NULL | Edit Mask |
| 13 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |