IB_PACKAGEIDPrompt Table: PSLSDEFNPACK_VW
IB_SCHEMANAMEPrompt Table: PSLSDEFNSRCH_VW
IB_VARIANTNAMEPrompt Table: PSLSDEFNVARS_VW
FS_MAP_TRG_FLDPrompt Table: FS_DOC_RLTS_FLD
FS_DOC_RLTS_TRG(SQL View) |
Index Back |
|---|
| SELECT IB_PACKAGEID , IB_SCHEMANAME , IB_VARIANTNAME , FS_MAP_FLD_NAME , FS_MAP_NODE , FS_MAP_FLD_DISP FROM PS_FS_DOC_RLTS_FLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IB_PACKAGEID |
Character(100) | VARCHAR2(100) NOT NULL |
Referenced Package
Prompt Table: PSLSDEFNPACK_VW |
| 2 | IB_SCHEMANAME |
Character(100) | VARCHAR2(100) NOT NULL |
Document Name
Prompt Table: PSLSDEFNSRCH_VW |
| 3 | IB_VARIANTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Version Name
Prompt Table: PSLSDEFNVARS_VW |
| 4 | FS_MAP_TRG_FLD |
Character(5) | VARCHAR2(5) NOT NULL |
Target Field
Prompt Table: FS_DOC_RLTS_FLD |
| 5 | FS_MAP_NODE | Character(220) | VARCHAR2(220) NOT NULL | Map Node |
| 6 | FS_MAP_FLD_DISP | Character(254) | VARCHAR2(254) NOT NULL | Display Name |