PIR_SEL_HDR

(SQL Table)
Index Back

PIR_SEL_HDR

PIR Payment Selection Run Control Header Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 REQUEST_DT Date(10) DATE Request Date
5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

9 RESET_SELECT_PB Character(1) VARCHAR2(1) NOT NULL Reset Selection

Y/N Table Edit

Default Value: N

10 FROM_PYMNT_DT Date(10) DATE To Payment Date

Default Value: %Date

11 TO_PYMNT_DT Date(10) DATE To Payment Date

Default Value: %Date

12 DATE_INC_SIZE Number(3,0) SMALLINT NOT NULL Date Increment Size

Default Value: 1

13 DATE_INC_TYPE Character(1) VARCHAR2(1) NOT NULL Date Increment Type
D=Day(s)
M=Month(s)
W=Week(s)

Default Value: D

14 PB_INC_ALL_AMT Character(1) VARCHAR2(1) NOT NULL Increment
15 PB_DEC_ALL_AMT Character(1) VARCHAR2(1) NOT NULL Decrement
16 RESET_FLAG Character(1) VARCHAR2(1) NOT NULL Reset Flag

Y/N Table Edit

Default Value: N