DTTM_PROCESSEDPrompt Table: AP_SCHED_ID_HDR
RUNDATERUNTIMEC=Complete
CE=Complete with Errors
E=Error
P=In Process
R=Received by Bank
S=Sent to Bank
X=Canceled
Default Value: P
AP_SCHED_ID_VW(SQL View) |
Index Back |
|---|---|
Fed. Payment Schedule ID ReconFederal Payment ID Schedule Reconciliation Search Record for Inquiry Component |
| SELECT DTTM_PROCESSED , %DatePart(DTTM_PROCESSED) , %TimePart(DTTM_PROCESSED) , PROCESS_INSTANCE , OPRID , RUN_CNTL_ID , REQUEST_NBR , FILE_PATH_NAME , FILE_NAME , FILE_STATUS FROM PS_AP_SCHED_ID_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DTTM_PROCESSED |
DateTime(26) | TIMESTAMP |
Datetime processed
Prompt Table: AP_SCHED_ID_HDR |
| 2 | RUNDATE |
Date(10) | DATE | Process Scheduler Run Date |
| 3 | RUNTIME |
Time(15) | TIMESTAMP | Process Scheduler Process Run Time |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 7 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 8 | FILE_PATH_NAME | Character(254) | VARCHAR2(254) NOT NULL | File Path |
| 9 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 10 | FILE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
File Status
C=Complete CE=Complete with Errors E=Error P=In Process R=Received by Bank S=Sent to Bank X=Canceled Default Value: P |