OPRIDRUN_CNTL_IDSEQ_NUM0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
5=Time
6=Datetime
7=Y/N Field
GPDE_CT_PARAM(SQL Table) |
Index Back |
|---|---|
CT Parameter Transfer TableGerman Certificates. This tables transferes parameters defined before creating a new certificate for an EE to the appropriate AE module. The content is based on the parameter setuptable and on the values the user enters and is deleted after the cert is created succsessfully by the systme. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | GPDE_FM_FLD_NAME | Character(254) | VARCHAR2(254) NOT NULL | Form Field Name |
| 5 | GPDE_CT_FIELDTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field type of entered Field (char, date, num etc)
0=Character 1=Long Character 2=Number 3=Signed Number 4=Date 5=Time 6=Datetime 7=Y/N Field |
| 6 | CHAR_VAL | Character(50) | VARCHAR2(50) NOT NULL | Character Value |
| 7 | DATE_VAL | Date(10) | DATE | Date Value |
| 8 | NUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Numeric Value |