GPFR_AD_DORE_VW(SQL View) |
Index Back |
---|---|
ADS Entry - Data Object NameApplication Framework ADS Entry - This record is used to retrieve a list of Data Object Name 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 COUNTRY ,GPFR_AF_APPL ,GPFR_AF_DON ,DESCR ,GPFR_AF_VERSION ,LAST_UPDT_DTTM ,LAST_UPDT_OPRID FROM PS_GPFR_AF_DON_REC |
# | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | GPFR_AF_VERSION | Character(18) | VARCHAR2(18) NOT NULL |
Application Framework object version.
Prompt Table: GPFR_AF_DORV_VW |
6 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
7 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |