OPR_DEF_TBL_CS

(SQL Table)
Index Back

Supplier Contract Management

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 CS_UPDATE_CURRENT Character(1) VARCHAR2(1) NOT NULL Reset to Dispatch

Y/N Table Edit

Default Value: N

3 CS_FULL_ACCESS Character(1) VARCHAR2(1) NOT NULL Full Authorization for All Doc

Y/N Table Edit

Default Value: N

4 CS_ADMIN_ACCESS Character(1) VARCHAR2(1) NOT NULL Document Administrator

Y/N Table Edit

5 CS_SECT_APPR_FLG Character(1) VARCHAR2(1) NOT NULL Approve Sections

Y/N Table Edit

Default Value: N

6 CS_TMPL_APPR_FLG Character(1) VARCHAR2(1) NOT NULL Configurator Status Change

Y/N Table Edit

Default Value: N

7 CS_SKIP_APPROVAL Character(1) VARCHAR2(1) NOT NULL Bypass Approval

Y/N Table Edit

Default Value: N

8 CS_IMPORT_APPR Character(1) VARCHAR2(1) NOT NULL Import Document

Y/N Table Edit

Default Value: N

9 CS_DEF_CL_STATUS Character(1) VARCHAR2(1) NOT NULL Default Clause Status
A=Approved
I=Initial

Default Value: I

10 CS_DEF_SEC_STATUS Character(1) VARCHAR2(1) NOT NULL Default Section Status
A=Approved
I=Initial

Default Value: I

11 CS_DEL_DOC Character(1) VARCHAR2(1) NOT NULL Delete Documents

Y/N Table Edit

Default Value: N