RE_ADT_STS_SRCH(SQL View) |
Index Back |
---|---|
Audit Status SearchOperating Expense Audit Status Setup Record Search View |
SELECT A.SETID , A.AUDIT_STATUS , A.INSTANCE_NAME FROM PS_RE_AUDIT_STATUS A WHERE (%CurrentDateIn BETWEEN A.EFFDT AND A.END_EFFDT) OR (A.EFFDT = ( SELECT MIN(C.EFFDT) FROM PS_RE_AUDIT_STATUS C WHERE C.SETID = A.SETID AND C.AUDIT_STATUS = A.AUDIT_STATUS AND C.EFFDT > %CurrentDateIn) AND NOT EXISTS ( SELECT 1 FROM PS_RE_AUDIT_STATUS B WHERE B.SETID = A.SETID AND B.AUDIT_STATUS = A.AUDIT_STATUS AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | AUDIT_STATUS | Character(10) | VARCHAR2(10) NOT NULL | Operating Expense Audit Status Field |
3 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Instance Name |