COUNTRYPrompt Table: GPFR_AF_CNTY_VW
GPFR_AF_APPLPrompt Table: GPFR_AF_APPL_VW
GPFR_AF_DONPrompt Table: GPFR_AF_DON_REC
GPFR_AF_SQL_SEQPrompt Table: GPFR_AF_DON_SQL
GPFR_AF_SQL_ENTITYPrompt Table: GPFR_AF_SQLENTY
Prompt Table: GPFR_AF_DOSV_VW
GPFR_AD_DOSQ_VW(SQL View) |
Index Back |
|---|---|
ADS Entry - Data Obj Name SQLApplication Framework ADS Entry - This record is used to retrieve a list of Data Object Name SQL rows when searching for rows to be included in an ADS package. It also enhance the search of rows providing prompt tables for the search fields. |
| SELECT S.COUNTRY ,S.GPFR_AF_APPL ,S.GPFR_AF_DON ,S.GPFR_AF_SQL_SEQ ,S.GPFR_AF_SQL_ENTITY ,R.DESCR ,S.GPFR_AF_VERSION ,S.LAST_UPDT_DTTM ,S.LAST_UPDT_OPRID FROM PS_GPFR_AF_DON_SQL S , PS_GPFR_AF_DON_REC R WHERE R.COUNTRY = S.COUNTRY AND R.GPFR_AF_APPL = S.GPFR_AF_APPL AND R.GPFR_AF_DON = S.GPFR_AF_DON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GPFR_AF_CNTY_VW |
| 2 | GPFR_AF_APPL |
Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Application
Prompt Table: GPFR_AF_APPL_VW |
| 3 | GPFR_AF_DON |
Character(16) | VARCHAR2(16) NOT NULL |
Application Framework - Data Object Name
Prompt Table: GPFR_AF_DON_REC |
| 4 | GPFR_AF_SQL_SEQ |
Number(8,0) | INTEGER NOT NULL |
Application Framework - SQL Sequence
Prompt Table: GPFR_AF_DON_SQL |
| 5 | GPFR_AF_SQL_ENTITY |
Character(16) | VARCHAR2(16) NOT NULL |
Application Framework - SQL Entity
Prompt Table: GPFR_AF_SQLENTY |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | GPFR_AF_VERSION | Character(18) | VARCHAR2(18) NOT NULL |
Application Framework object version.
Prompt Table: GPFR_AF_DOSV_VW |
| 8 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
| 9 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |