OPS_KEY_NODEPrompt Table: %EDITTABLE
OPS_NODE_VW(SQL View) |
Index Back |
|---|---|
DUCS Node Info ViewDUCS Node Info View |
| SELECT GPFR_AF_KEY_NODE ,GPFR_AF_NODE_NAME FROM PS_GPFR_AF_NODE WHERE COUNTRY='FRA' AND GPFR_AF_APPL='DSN' AND GPFR_AF_NODE_NAME IN( SELECT B.GPFR_AF_DRPDN_VAL FROM PS_GPFR_AF_PRMTMPT A , PS_GPFR_AF_PRMSEC B WHERE A.COUNTRY=B.COUNTRY AND A.GPFR_AF_APPL = B.GPFR_AF_APPL AND A.GPFR_AF_PARM_SEQ = B.GPFR_AF_PARM_SEQ AND A.GPFR_AF_PARM_NM='DUCS_NODES' AND A.GPFR_AF_FUNCT_NM='OPS' AND A.GPFR_AF_PRM_CNTL='DD' AND B.COUNTRY='FRA' AND B.GPFR_AF_APPL='DSN') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPS_KEY_NODE |
Number(8,0) | INTEGER NOT NULL |
OPS - Key Node
Prompt Table: %EDITTABLE |
| 2 | OPS_NODE_NAME | Character(20) | VARCHAR2(20) NOT NULL | OPS - Node Name |