RUN_GLS1211

(SQL Table)
Index Back

Closing sets Validation

# 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 RUN_CNTL_ID_SCHED Character(30) VARCHAR2(30) NOT NULL Resource Schedule Report ID

Prompt Table: KK_CLOSE_REQ_VW

4 KK_ROLL_FWD_VAL Character(1) VARCHAR2(1) NOT NULL Roll Fwd Calc - Spending Auth
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

5 KK_RULE_OVRLAP_VAL Character(1) VARCHAR2(1) NOT NULL Closing rules overlap
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

6 KK_NO_CHILDBD_VAL Character(1) VARCHAR2(1) NOT NULL Flag used in Budget Closing Set validation request.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

7 KK_NO_PARENTBD_VAL Character(1) VARCHAR2(1) NOT NULL Flag used in Budget Closing Set validation request.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

8 KK_CHILD_FWD_VAL Character(1) VARCHAR2(1) NOT NULL Child Budg set Fwd, parent not
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

9 KK_PARENT_FWD_VAL Character(1) VARCHAR2(1) NOT NULL Flag used in Budget Closing Set validation request.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

10 KK_NO_REVBD_VAL Character(1) VARCHAR2(1) NOT NULL To validate that when the expenditure budget is to be closed, the associated revenue budget(s) should be closed as well.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

11 KK_NO_EXPBD_VAL Character(1) VARCHAR2(1) NOT NULL To validate that when the revenue budget is to be closed, the expenditure budget that it is associated to should be closed as well.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

12 KK_EXP_FWD_VAL Character(1) VARCHAR2(1) NOT NULL Exp. Budget set Fwd, not Rev.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

13 KK_REV_FWD_VAL Character(1) VARCHAR2(1) NOT NULL Revenue Budg set Fwd, not Exp.
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

14 KK_ROWS_COVER_VAL Character(1) VARCHAR2(1) NOT NULL Budget Rows not covered
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

15 KK_BP_XFER_SET_VAL Character(1) VARCHAR2(1) NOT NULL Bud Period not in Transfer Set
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

16 KK_EARLY_PRIOD_VAL Character(1) VARCHAR2(1) NOT NULL Early Budg Periods not closed
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

17 KK_EARLY_YEAR_VAL Character(1) VARCHAR2(1) NOT NULL Earlier fiscal year not closed
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E

18 KK_ENTRY_EVENT_VAL Character(1) VARCHAR2(1) NOT NULL Entry Event not Defined
E=Fail the Validation
I=Ignore
W=Report as a Warning

Default Value: E