CLOSE_GRP_STEP

(SQL Table)
Index Back

Closing Group Step

# 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 CLOSE_GRP_ID Character(20) VARCHAR2(20) NOT NULL Closing Process Group
3 CLOSING_TYPE Character(1) VARCHAR2(1) NOT NULL Closing Type
I=Interim
Y=Year End
4 VERSION_GRP Number(3,0) SMALLINT NOT NULL Group Version
5 CLOSING_SET Character(20) VARCHAR2(20) NOT NULL Closing Rule

Prompt Table: CLOSRUL_NOEF_VW

6 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

Default Value: 0

Prompt Table: CLOSRUL_DESC_VW

7 CLOSE_STEP Number(3,0) SMALLINT NOT NULL Closing Step
8 CLOSE_FIRST_STEP Character(1) VARCHAR2(1) NOT NULL Closing Group First Step

Y/N Table Edit

Default Value: N

9 CLOSE_LAST_STEP Character(1) VARCHAR2(1) NOT NULL Closing Group Last Step

Y/N Table Edit

Default Value: N