RUNCTL_HR_I9

(SQL Table)
Index Back

I9 runcontrol rec

Used for reporting in I9

# 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 FROM_DT Date(10) DATE From Date
4 THRU_DT Date(10) DATE Sal Package - Thru Date
5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERALL_SEC_SRCH

7 I9_EXP_DOC_FLG Character(1) VARCHAR2(1) NOT NULL Expired Docs flag

Y/N Table Edit

Default Value: Y

8 I9_UPDATE_DOC_FLG Character(1) VARCHAR2(1) NOT NULL Application Update flag

Y/N Table Edit

Default Value: Y

9 I9_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Report Run Type
C=By Company
E=By Employee

Default Value: C

10 I9_ADD_WORKLIST Character(1) VARCHAR2(1) NOT NULL Add into WL flag

Y/N Table Edit

11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 RULE_SQLID Character(23) VARCHAR2(23) NOT NULL Rule SQLID