RS_COMPOS_TEST

(SQL Table)
Index Back

# 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 OWNING_ORG_FLAG Character(1) VARCHAR2(1) NOT NULL Owning Organization
0=No
1=Yes

Default Value: 1

4 RS_RSRC_STAT_OPT Character(1) VARCHAR2(1) NOT NULL Personnel Status
A=All
E=Employees
N=Non-Employees

Default Value: A

5 ALL_RESOURCES_FLAG Character(1) VARCHAR2(1) NOT NULL All Resources
0=No
1=Yes

Default Value: 0

6 ALL_RR_FLAG Character(1) VARCHAR2(1) NOT NULL All Resource Requests
0=No
1=Yes

Default Value: 0

7 RESOURCE_MATCH_TYP Character(1) VARCHAR2(1) NOT NULL Resource Match Type
0=Reverse Search/Resource Facing
1=Forward Search/RR Facing

Default Value: 1

8 SESSION_ID Number(6,0) INTEGER NOT NULL Session ID
9 MAX_COUNT_99 Number(2,0) SMALLINT NOT NULL Maximum Number of Candidates

Default Value: 10