GPFR_DSN_FL2_VW(SQL View) |
Index Back |
---|---|
DSN FileDSN File view from GPFR_AF_EXTRACT |
SELECT TEMP.GPFR_AF_EXTRACT_ID , TEMP.GPFR_AF_NODE_SET , TEMP.COMPANY , TEMP.EMPLID , TEMP.EMPL_RCD , TEMP.GPFR_AF_SIT_BGN_DT , TEMP.GPFR_AF_SIT_END_DT , TEMP.GPFR_AF_KEY_EXTRCT , TEMP.GPFR_AF_KEY_NODE , TEMP.GPFR_AF_KEY_ATTR , TEMP.GPFR_AF_APPL_VER , TEMP.GPFR_AF_NODE_NAME , TEMP.GPFR_AF_ATTR_NAME , TEMP.ESTABID , TEMP.GPFR_AF_CHAR_VAL , TEMP.GPFR_AF_DATE_VAL , TEMP.GPFR_AF_NUM_VAL , ' ' , TEMP.GPFR_AF_ATTR_TYPE , TEMP.GPFR_AF_ATR_LENGTH , TEMP.GPFR_AF_ATR_DECIML , TEMP.GPFR_AF_RND_NM_VAL FROM ( SELECT X.GPFR_AF_EXTRACT_ID , X.GPFR_AF_NODE_SET , X.COMPANY , X.EMPLID , X.EMPL_RCD , X.GPFR_AF_SIT_BGN_DT , X.GPFR_AF_SIT_END_DT , X.GPFR_AF_KEY_EXTRCT , X.GPFR_AF_KEY_NODE , X.GPFR_AF_KEY_ATTR , A.GPFR_AF_APPL_VER , X.GPFR_AF_NODE_NAME , X.GPFR_AF_ATTR_NAME , X.ESTABID , X.GPFR_AF_CHAR_VAL , X.GPFR_AF_DATE_VAL , X.GPFR_AF_NUM_VAL , ' ' GPFR_AF_VALUE , A.GPFR_AF_ATTR_TYPE , A.GPFR_AF_ATR_LENGTH , A.GPFR_AF_ATR_DECIML , X.GPFR_AF_RND_NM_VAL FROM PS_GPFR_AF_EXTRACT X , PS_GPFR_AF_ATTR A , PS_GPFR_AF_RUN_PRM P WHERE X.COUNTRY = 'FRA' AND X.GPFR_AF_APPL = 'DSN' AND P.GPFR_AF_EXTRACT_ID = X.GPFR_AF_EXTRACT_ID AND P.GPFR_AF_FUNCT_NM = 'RUN_CTL' AND P.GPFR_AF_PARM_NM = 'VERSION' AND A.COUNTRY = X.COUNTRY AND A.GPFR_AF_APPL = X.GPFR_AF_APPL AND A.GPFR_AF_KEY_NODE = X.GPFR_AF_KEY_NODE AND A.GPFR_AF_KEY_ATTR = X.GPFR_AF_KEY_ATTR AND A.GPFR_AF_APPL_VER = ( SELECT MAX(A2.GPFR_AF_APPL_VER) FROM PS_GPFR_AF_ATTR A2 WHERE A2.COUNTRY = A.COUNTRY AND A2.GPFR_AF_APPL = A.GPFR_AF_APPL AND A2.GPFR_AF_KEY_NODE = A.GPFR_AF_KEY_NODE AND A2.GPFR_AF_KEY_ATTR = A.GPFR_AF_KEY_ATTR AND A2.GPFR_AF_APPL_VER <= %Sql(GPFR_CHAR_TO_NUM, P.GPFR_AF_CHAR_VAL)) AND A.GPFR_AF_ATTR_STAT = 'A' AND A.GPFR_AF_RPT_ONLY <> 'Y' AND (A.GPFR_AF_MANDATORY = 'Y' OR (X.GPFR_AF_NUM_VAL <> 0 OR X.GPFR_AF_CHAR_VAL <> ' ' OR X.GPFR_AF_DATE_VAL IS NOT NULL)) ) TEMP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPFR_AF_EXTRACT_ID | Character(18) | VARCHAR2(18) NOT NULL | Application Framework - Extraction ID |
2 | GPFR_AF_NODE_SET | Character(16) | VARCHAR2(16) NOT NULL | Application Framework - Node Set |
3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
6 | GPFR_AF_SIT_BGN_DT | Date(10) | DATE NOT NULL | Application Framework - Situation Begin Date |
7 | GPFR_AF_SIT_END_DT | Date(10) | DATE NOT NULL | Application Framework - Situation End Date |
8 | GPFR_AF_KEY_EXTRCT | Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Key Extract |
9 | GPFR_AF_KEY_NODE | Number(8,0) | INTEGER NOT NULL | Application Framework - Key Node |
10 | GPFR_AF_KEY_ATTR | Number(8,0) | INTEGER NOT NULL | Application Framework - Key Attribute |
11 | GPFR_AF_APPL_VER | Number(8,0) | INTEGER NOT NULL | Application Framework - Application |
12 | GPFR_AF_NODE_NAME | Character(20) | VARCHAR2(20) NOT NULL | Application Framework - Node Name |
13 | GPFR_AF_ATTR_NAME | Character(12) | VARCHAR2(12) NOT NULL | Application Framework - Attribute Name |
14 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
15 | GPFR_AF_CHAR_VAL | Character(50) | VARCHAR2(50) NOT NULL | Application Framework - Character |
16 | GPFR_AF_DATE_VAL | Date(10) | DATE | Application Framework - Date |
17 | GPFR_AF_NUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Application Framework - Number |
18 | GPFR_AF_VALUE | Character(60) | VARCHAR2(60) NOT NULL | Application Framework - Value |
19 | GPFR_AF_ATTR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Application Framework - *Attribute Type
D=Date M=Monetary N=Numeric T=Text |
20 | GPFR_AF_ATR_LENGTH | Number(3,0) | SMALLINT NOT NULL | Application Framework - *Attribute Length |
21 | GPFR_AF_ATR_DECIML | Number(2,0) | SMALLINT NOT NULL | Application Framework - Attribute Decimal |
22 | GPFR_AF_RND_NM_VAL | Number(12,0) | DECIMAL(12) NOT NULL | Application Framework - Round Number Value |