GPFR_DUCS_CDGPFR_DUCS_TYPEGPFR_DUCS_NUMBERGPFR_ASS_DATETIMEDefault Value: %Datetime
GPFR_DUCSF_SRCH(SQL View) |
Index Back |
|---|---|
DUCS File Update Search ViewDUCS File Update Search View. |
| SELECT DISTINCT A.GPFR_DUCS_CD , A.GPFR_DUCS_TYPE , A.GPFR_DUCS_NUMBER , A.GPFR_ASS_DATETIME FROM PS_GPFR_DUCS_DEB A WHERE A.GPFR_ASS_DATETIME IN ( SELECT MAX(B.GPFR_ASS_DATETIME) FROM PS_GPFR_DUCS_DEB B WHERE A.GPFR_DUCS_CD=B.GPFR_DUCS_CD AND A.GPFR_DUCS_TYPE = B.GPFR_DUCS_TYPE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPFR_DUCS_CD |
Character(10) | VARCHAR2(10) NOT NULL | GPFR: DUCS Code |
| 2 | GPFR_DUCS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | GPFR: DUCS Type |
| 3 | GPFR_DUCS_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | DUCS Process Instance |
| 4 | GPFR_ASS_DATETIME |
DateTime(26) | TIMESTAMP |
GPFR: DateTime
Default Value: %Datetime |