GLRN_CREUOW_REQ

(SQL Table)
Index Back

Create Unit of Recon Request

Run Control for creating Unit of Reconciliation

# 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_NBR Number(4,0) SMALLINT NOT NULL Request Number

Default Value: 9999

4 AS_OF_DATE Date(10) DATE NOT NULL As of Date

Default Value: %date

5 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set

Prompt Table: GLRN_SET_TBL

6 GLRN_RULE Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Rule ID

Prompt Table: GLRN_SETRUL_VW

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 COPY_FROM_PREV Character(1) VARCHAR2(1) NOT NULL Flag - Adhoc reconciliation

Y/N Table Edit

Default Value: N

9 AS_OF_DATE_FROM Date(10) DATE As of Date From

Prompt Table: GLRN_CREUOW_VW

10 RECREATE_IF_EXIST Character(1) VARCHAR2(1) NOT NULL Recreate if UOW rows already exist

Y/N Table Edit

Default Value: N

11 GLRN_RECON_STATUS Character(1) VARCHAR2(1) NOT NULL Reconciliation Status

Prompt Table: GLRN_STATUS_TBL

12 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

13 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

14 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

Default Value: N

15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
16 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.