SSR_TST_CLT_NLD(SQL Table) |
Index Back |
---|---|
Calc. result and related testsCalc. result and related tests |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_TST_ID_NLD | Character(8) | VARCHAR2(8) NOT NULL | Test ID |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
4 | SSR_TST_CHLDID_NLD | Character(8) | VARCHAR2(8) NOT NULL |
Child Test ID
Prompt Table: SSR_TSTCTLGT_VW |
5 | SSR_TST_WEIGHT_NLD | Character(2) | VARCHAR2(2) NOT NULL | Weight |
6 | SSR_COMP_OPER_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Operators
<=< <==<= === >=> >==>= |
7 | SSR_MIN_VALUE_NLD | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Value |
8 | SSR_TST_REPEAT_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Repeat
A=Average H=Highest L=Latest Default Value: H |